How to calculate age in Excel

How to calculate age in Excel You can calculate a persons age based on their birthday and Today 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!) A B Birth Date 2-Feb-75 Years Lived 41  =DATEDIF(B2,TODAY(),"y") And the Months 10  =DATEDIF(B2,TODAY(),"ym") And the Days 10  =DATEDIF(B2,TODAY(),"md") You can put this all together in one calculation, which creates a text version. Age is 56 Years, 11 Months and 11 Days  ="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. Birth Date 1-Jan-60 Age Is 56.95  =(TODAY()-C23)/365.25 A B Birth Date 2-Feb-75 Years Lived 41  =DATEDIF(B2,TODAY(),"y") And the Months 10  =DATEDIF(B2,TODAY(),"ym") And the Days 10  =DATEDIF(B2,TODAY(),"md") Birth Date 1-Jan-60 Age Is 56.95  =(TODAY()-C23)/365.25