Calculating age

[Guest]

How can I calculate a persons age from a birthdate in excel?

 

[JudithJubilee]

This is a quick way but not the best:

If you put the birthdate in A1:

=(TODAY()-A1)/365

You will need to format the cell with General formatting.

Judith

 

[Guest]

HI,


=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW
(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days"

From Chip Pearson's site:

http://www.cpearson.com/excel/datedif.htm#Age

 

[Llobid]

Just read this one in another post...

Try:

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

 

[Guest]

Datedif did the trick. Thanks to all