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")&"D AYS"

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 ,
"Leyland" 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")&"D AYS"

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 ,
"Leyland" 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")&"D AYS"