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. Anyone have the formula
for that?

Thanks in advance!
Trish

 

[Chip Pearson]

Trish,

You can use the DATEDIF function to do this. E.g.,

=DATEDIF(date_of_birth,DATE(2004,6,1),"y")

See www.cpearson.com/excel/datedif.htm for more details about
DATEDIF.

 

[Ron Rosenfeld]

Hi all,

I need to compute ages (as of 6-1-04) from dates of birth
on a speadsheet I'm working on. Anyone have the formula
for that?

Thanks in advance!
Trish

=DATEDIF(dob,DATE(2004,6,1),"y")

--ron

 

[cincode5]

Trish,

Try using the following:
=IF(DATE(2004,6,1)=F11,IF(TODAY()-G11>365,INT((TODAY()-G11)/365)&" Years",TODAY()-G11&" Days"),"")

F11 = the as of date
G11 = DOB