Age formula using birthdate

Lisa · Oct 1, 2003

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 · Oct 1, 2003

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