Microsoft Excel Functions & Formulas

Use the DATEDIF function to calculate the ages

of employees

To calculate the exact age of employees, use the undocumented

DATEDIF function from the Analysis ToolPak add-in. This function

calculates the exact number of years, months, and days between

two dates. The syntax is:

DATEDIF(start_date, end_date, format)

start_date: The start date.

end_date: The end date.

format: Indicates the format to use. “y” gives the difference in

years; “m” in months; “d” in days; “ym” the difference in

months, ignoring the year; “yd” in days, ignoring the year; and

“md” in days, ignoring the month and year.

4

To calculate the ages of employees:

1. In column A list the names ...