Calculate age

[Jay M]

I want to calculate age for entries in a spreadsheet.
Each person on a row has DOB entered. I entered the
reference date (9/30/2003) in another cell and now am
using the formula for calculating the # years between the
2 dates. I want full years only. i.e. if DOB is
10/15/1990, the age should come up to be 12 not 13 as of
9/30/2003. But it keeps showing 13. I've tried using
the TRUNC command and also INT. Still the same result.
What's the problem?

 

[Vasant Nanavati]

What formula are you using?

I'm not sure if the DATEDIF function still exists, so try the following:

=YEAR(B1)-YEAR(A1)-(MONTH(A1)>MONTH(B1))-(MONTH(A1)=MONTH(B1))*(DAY(A1)>DAY(
B1))

 

[Peo Sjoblom]

=DATEDIF(DOB,Ref_date,"y")

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Don Guillett]

I used Ron's add in http://www.rondebruin.nl/
to search the subject for calculate age and got
http://tinyurl.com/2mllh

 

[Harald Staff]

That depends on what "the formula for calculating the # years" is. Care to
post it ?

Best wishes Harald

 

[Paul]

Or, if you want to compare the DOB to today's date,
substitute "Now()" for "Ref_Date".