How do I calculate an age from a birthdate in excel?
J JulieD Nov 29, 2004 #2 Hi formula from http://www.cpearson.com/excel/datedif.htm#Age =DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days" Cheers JulieD
Hi formula from http://www.cpearson.com/excel/datedif.htm#Age =DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days" Cheers JulieD