Hints and tips home » Excel hints and tips » calculate age or service

calculate age or service

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:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

Added by Meenesh on 3rd October 2006

More Excel hints and tips, like:

• Change the Value of a Constant
• Select blank cells automatically
• Validating text entries