ExcelBanter - DATEDIF and leap years

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - DATEDIF and leap years (https://www.excelbanter.com/new-users-excel/36334-datedif-leap-years.html)

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