MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I calculate someone's age using excel?


Posted by Aimee on September 13, 2001 12:02 AM

Hi,

I'm just trying to find out the formula for calcuating the age of a person from their date of birth.

Thanks.
Aimee.


Posted by . on September 13, 2001 1:45 AM

Search the archives - has been covered many times

Posted by Paul on September 13, 2001 8:20 AM

=DATEDIF(B4,NOW(),"y")&"y,"&DATEDIF(B4,NOW(),"ym")&"m,"&DATEDIF(B4,NOW(),"md")&"d" Put the birthday in cell A1

Posted by Paul on September 13, 2001 10:32 AM

sorry birthday should go in B4 or change the B4 to A1