Age Calculation

Posted on 17-01-2020 , by: admin , in , 0 Comments

Age Calculation

  • 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!)
Birth date : 29-Apr-73

Years lived : 46 =DATEDIF(C8,TODAY(),"y")
and the months : 8 =DATEDIF(C8,TODAY(),"ym")
and the days : 19 =DATEDIF(C8,TODAY(),"md")

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

Age is 46 Years, 8 Months and 19 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 : 01-Jan-60

Age is : 60.04 =(TODAY()-C23)/365.25

Leave a comment