Date to Date Including Leap Day

[mrivera]

I am trying to calculate from date to date that includes Leap Day.
In my example the results should be 1 Year, 0 Months and 1 Day.

1/1/2020​

1/1/2021​

1 years, 0 months, 0 days

The formula I have currently is
=DATEDIF(A1,B1,"y")&" years, "&DATEDIF(A1,B1,"ym")&" months, "&B1-DATE(YEAR(B1),MONTH(B1),1)&" days"

Thanks for your help.

 

[Snakehips]

@mrivera Welcome.
What makes you consider it to be incorrect?
Every 4 years, a the leap year will comprise 366 days rather than 365.

 

[mrivera]

That was my thought too.
But my HR department wants to know the Extra days that leap year adds.
They want to know if a person has been here 4 year plus the extra 1 day or 8 years plus 2 days.
I suppose it make a difference to them? I'm just trying to please them.

 

[Joe4]

That was my thought too.
But my HR department wants to know the Extra days that leap year adds.
They want to know if a person has been here 4 year plus the extra 1 day or 8 years plus 2 days.
I suppose it make a difference to them? I'm just trying to please them.

That is faulty logic. If a person is 40 years old, so they have lived through 10 leaps years, on their 40th birthday, you would not say that they are 40 years and 10 days old.
A year is actually more than 365 days. More precisely, it is 365.2422 days (see: Which years are leap years and can you have leap seconds?.).

If, for your HR purposes, they are treated 365 days as the number of days in a year, then just subtract the two days and divide by 365.
I would recommend keeping the answer in decimal form, or do just years and days.
Otherwise, you get into another mess when you try to decide how many days there are in a month (it wouldn't be exactly 30 unless you say there are 360 days in a year).