DATEDIF and leap years

I am using this formula to get the age of someone in years and days. It
works well execpt I cannot find a way of adjusting for leap years. Any ideas

=DATEDIF(A1,B1,"Y")&"YEARS"&DATEDIF(A1,B1."YD")&"DAYS"

What isn't adjusting for you?

A1: 2/28/2001
B1: 3/1/2004 <== Leap year
C1: 3 YEARS 2 DAYS


A1: 2/28/2002
B1: 3/1/2005 <== Non leap-year
C1: 3 YEARS 1 DAYS

Years are insensitive to leap-days (except for those born on 29
February, I suppose), so only the last partial year matters. It appears
to me that this adjusts fine.



In article <FAF4D262-60B9-4777-ABA6-C6BB6F7FFCFA@microsoft.com>,
"Leyland" <Leyland@discussions.microsoft.com> wrote:

> I am using this formula to get the age of someone in years and days. It
> works well execpt I cannot find a way of adjusting for leap years. Any ideas
>
> =DATEDIF(A1,B1,"Y")&"YEARS"&DATEDIF(A1,B1."YD")&"DAYS"

Sorry, my bad maths! I have run it again with no problems. Many thanks.

"JE McGimpsey" wrote:

> What isn't adjusting for you?
>
> A1: 2/28/2001
> B1: 3/1/2004 <== Leap year
> C1: 3 YEARS 2 DAYS
>
>
> A1: 2/28/2002
> B1: 3/1/2005 <== Non leap-year
> C1: 3 YEARS 1 DAYS
>
> Years are insensitive to leap-days (except for those born on 29
> February, I suppose), so only the last partial year matters. It appears
> to me that this adjusts fine.
>
>
>
> In article <FAF4D262-60B9-4777-ABA6-C6BB6F7FFCFA@microsoft.com>,
> "Leyland" <Leyland@discussions.microsoft.com> wrote:
>
> > I am using this formula to get the age of someone in years and days. It
> > works well execpt I cannot find a way of adjusting for leap years. Any ideas
> >
> > =DATEDIF(A1,B1,"Y")&"YEARS"&DATEDIF(A1,B1."YD")&"DAYS"
>