Microsoft Excel Functions & Formulas

Use the YEARFRAC function to calculate ages

of employees

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. (NASD) 30/360,

1 = actual/actual, 2 = actual/360, 3 = actual/365, or4=Euro-

pean 30/360.

4

To calculate the age of employees based on the current

date:

1. In column A list the names of employees.

2. In column B enter their birthdays. ...