DOB Formula

[excel_stu]

Is there a formula that can work out a persons age from a date?

Eg.

Col A1 Col B2
28/12/1981 24

 

[R_Stephens]

Hi excel_stu,

try this

=ROUNDDOWN((NOW()-A1)/365,0)

Hope it helps

Richard

 

[njimack]

R_Stephens,

Your formula returns an age of 31 with a DOB of 7/9/75 (i.e someone who would turn 31 tomorrow).

No doubt there's a much shorter solution, but I THINK the following works:

=IF(OR(AND(MONTH(TODAY())<MONTH(A1),DAY(TODAY())<DAY(A1)),AND(MONTH(TODAY())=MONTH(A1),DAY(TODAY())<=DAY(A1))),YEAR(TODAY())-YEAR(A1)-1,YEAR(TODAY())-YEAR(A1))

 

[barry houdini]

With DOB in A1

=DATEDIF(A1,Today(),"Y")

 

[NBVC]

Try

=Datedif(A1,Today(),"y") where A1 house the DOB

 

[excel_stu]

Hi excel_stu,

try this

=ROUNDDOWN((NOW()-A1)/365,0)

Hope it helps

Richard

Thanks that worked!

 

[excel_stu]

Thanks to all that helped!