How Many Leap Years Are There From 2024 To 2024 Calculator Excel. Dividing the total days by 365 doesn't work because of leap years. To count leap years between two dates, you just need to do as this:
Select a blank cell that you will place the counted. If you are trying to do date math where you are adding months or years to a date, it will ignore the day.