DateDif sometimes retrn WRONG Value for exm.:
calculate datedif (by days) for 12/31/2004
3/1/2005


"ness" wrote:

Thank you - a great help! Vanessa Leonard

"Bob Phillips" wrote:

Use the DATEDIF function.


=DATEDIF(birthdate,TODAY(),"y"Â*)


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


--

HTH

RP
(remove nothere from the email address if mailing direct)


"CPD174" wrote in message
...
I want to figure the age of a person based on two entered dates, their
birthday and another date of occurrance. I want this to reflect whether
or
not their birthday has yet occurred in this calendar year.