How to Use the YEARFRAC function to calculate employees ages
To calculate the difference between two dates, use the YEARFRAC function from the Analysis ToolPak add-in. This function calculates the fraction of the year represented by the number of whole days between start_date and end_date. The syntax is:
YEARFRAC(start_date, end_date, basis)
start_date: The start date.
end_date: The end date.
basis: Count basis to use. 0 or omitted = U.S. [...]
