Microsoft Excel Tips
and Tricks
Quickly Calculate a Person's Age in Excel
The DATEDIF() function in Excel calculates the number of
days, months, or years between two dates. So, this function
makes it easy to calculate a person's age. To try this tip:
1.
In a blank worksheet, type the birth date in cell A1, using
slashes to separate day, month, and year.
2.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.
The age (in years) will be displayed in cell A2.
Editor's Note:
For more information on the proper syntax to use for the IF
worksheet function, search for IF worksheet function
in Excel Help.
|