Age Formula

  • Thread starter Thread starter Trish
  • Start date Start date
T

Trish

Hi all,

I need to compute ages (as of 6-1-04) from dates of birth
on a speadsheet I'm working on. I have NO idea where to
start on that. Help please?

Thanks in advance!
Trish
 
Trish, take a look at this page:
http://www.cpearson.com/excel/datedif.htm#Age.

If 6-1-04 (which to me = June 1, 2004) is in, say, A1 and I have a list of
DOBs starting in A2, then

=DATEDIF(A2,A$1,"y") & " years, " & DATEDIF(A2,A$1,"ym") & " months, "&
DATEDIF(A2,A$1,"md") & " days"

in B2 gives me my result. I can then copy the formula down the column.
 
Hi Gord!

It was a crude reply from a moron! Fortunately, quite rare on these
groups.
 
Back
Top