Excel - Calc current age of a person
 

Hi

With birthdate in cell A1

Age in full years
=DATEDIF(A1,TODAY(),"Y")
Number of full months above age in years
=DATEDIF(A1,TODAY(),"YM")
Number of days abofe age in years and months
=DATEDIF(A1,TODAY(),"MD")


--
(Don't use my reply address - it's spam-trap)

Arvi Laanemets


"RichM" wrote in message
...
Need a formula to calc the current age if I have a field with the current
date and a field with the birthdate.