Age Formula

[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

 

[Don Guillett]

try this
=DATEDIF(C6,"6/10/04","Y")

 

[Anders Silven]

Asked and answered in .misc.
Please don't multipost.

Regards
Anders Silven

 

[DDM]

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.

 

[David]

Show what's under the double boulder holder and I'll tell
you.

 

[Gord Dibben]

Trish

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

David...WTF are you talking about???

Gord Dibben Excel MVP

 

[Norman Harker]

Hi Gord!

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