Calulating Age Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need Formula for calulating age from birthdate from current date. I have used
=VALUE((2005)-YEAR(birthdate)), but this gives me the age of year as of end
of 2005. I need formula to calulate age as of today's date or by current
month. I want to show the age in the cell next to the birthdate without
using a date reference from another cell.

Thanks.
 
YUMBUG wrote...
Need Formula for calulating age from birthdate from current date. I have used
=VALUE((2005)-YEAR(birthdate)), but this gives me the age of year as of end
of 2005. I need formula to calulate age as of today's date or by current
month. I want to show the age in the cell next to the birthdate without
using a date reference from another cell.
Click to expand...

=YEAR(TODAY()-birthdate)-YEAR(0)

would be one way using only documented function calls. Using the
usually undocumented DATEDIF requires something like

=DATEDIF(birthdate,TODAY(),"Y")
 
Thank you.

Harlan Grove said:
YUMBUG wrote...

=YEAR(TODAY()-birthdate)-YEAR(0)

would be one way using only documented function calls. Using the
usually undocumented DATEDIF requires something like

=DATEDIF(birthdate,TODAY(),"Y")
Click to expand...
 
Back
Top