=DATEDIF(A1,TODAY(),"y")&" year(s) and "&DATEDIF(A1,A2,"yd")&" day(S)"

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Neil" wrote in message
...
I am trying to calculate the number of years in a person's age by reference
to date of birth and today's date.
When I put DoB as 12/5/2003 against today's date of 11/05/2006, it comes
back as 3 whole years, when in fact it is 2 and 364 days. Excel seems to
be
ignoring the leap year in 2004. If I use 13/05/2003 as DoB, it comes back
correctly as just 2 years.
How can I correct fro this via a simpel formula?

Many thanks in advance for all help received?
Neil