Calculate age based on today's date

[frc]

I'm looking for a formula to be able to calculate a list of employee's ages
based on today's date.
Thanks!
M Burton

 

[JulieD]

Hi

from Chip Pearson's website (www.cpearson.com)

Here's a very exact formula off of Chip Pearson's website:


=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW

 

[Bernard Liengme]

Use the undocumented function DATEDIFF
I think Clip at www.cpearson.com has details

best wishes

 

[JulieD]

Hi
i'll try that again
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " &
DATEDIF(A1,NOW(),"md") & " days"

with the person's birthdate in A1.

Cheers
JulieD