Age formula using birthdate

[Lisa]

I'm not very good with formulas and I can't seem to figure
out how to get the age of someone when I have their
birthdate. Does anyone know how to do this?

 

[Biff]

Hi Lisa,

Enter the birthdate in say cell A1. Use this formula:

=DATEDIF(A1,TODAY(),"Y")&" "&"years"&" "&DATEDIF(A1,TODAY
(),"YD")&" "&"days"

This will return:

46 years 58 days (at least in MY case!)

Biff