98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

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:

• Creating a range of monthly payments as text
• Add Text to Displayed Numbers in Excel 2010
• Converting an American date format to European using Formula