# DATEDIF and leap years

1. ## 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"

2. ## Re: DATEDIF and leap years

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"

3. ## Re: DATEDIF and leap years

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"

>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1