How to Calculate Age in Excel

 

You can calculate a persons age based on their birthday and todays date.

The calculation uses the DATEDIF() function.

The DATEDIF() is not documented in Excel 5, 7 or 97, but it is in 2000.

(Makes you wonder what else Microsoft forgot to tell us!)

You can put this all together in one calculation, which creates a text version.

Age is 50 Years, 9 Months and 2 Days

And the Formula for this is:

="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days"

Another way to Calculate Age:

This method gives you an age which may potentially have decimal places representing the months.

If the age is 20.5, the .5 represents 6 months.