Counting days between two dates, but ignore leap year

tikitour 

You can modify the formula to check if the date range includes February 29th of a leap year and subtract 1 from the total number of days calculated by the DATEDIF function if it does.

Here's an example formula that should work for you:

=DATEDIF(P41,Q41,"d")-IF(AND(MONTH(P41)<=2,MONTH(Q41)>=3,YEAR(P41)=YEAR(Q41),OR(MOD(YEAR(P41),400)=0,AND(MOD(YEAR(P41),4)=0,MOD(YEAR(P41),100)<>0))),1,0)

This formula checks if the start date is before or on February and the end date is on or after March of the same year.

If this condition is true, it then checks if the year is a leap year by using the OR and AND functions along with the MOD function to check if the year is divisible by 400 or divisible by 4 but not divisible by 100.

If this condition is also true, it subtracts 1 from the total number of days calculated by the DATEDIF function.

Using this formula with your examples:

1. a) Start Date: 19/03/2023 End Date: 19/03/2024 Result: 365 days
2. b) Start Date: 21/10/2023 End Date: 20/04/2024 Result: 181 days
3. c) Start Date: 19/12/2021 End Date: 19/12/2022 Result: 365 days

I hope this helps! … and I got it right, this time 🙂