How To Calculate The Number Of Leap Years Between Two Dates In Excel

A leap year has one day more than a non-leap year, but it impacts a lot of calculations. The payroll for many companies are different for leap years, the profit calculations for business are impacted by leap years.

Calculate the number of leap years between two dates in Excel

The syntax to count the number of leap years between two dates in Excel is as follows: Where, and are the cells specifying the first and last date of the period between which you need the count of leap years. The dates are to be in MM/DD/YYYY format. The formula is to be entered in the cell where you need the result (the number of leap years between two dates in Excel). For example, if we need to calculate the number of leap years between 23rd March 1964 and 12th January 2018, we would first write the dates in MM/DD/YYYY format as follows:

Start date: 03/23/1964End date: 01/12/2018

Let us assume the start date is in cell B4, the end date is in cell C4, and the count of the number of leap years between these two dates is needed in cell E4, the formula would become: Enter this formula in cell E4 and click anywhere outside that cell.

You will get the count of the number of leap years between those two dates.

Count number of leap years between a list two dates in Excel

In case you have a list of start and end dates in an excel sheet, you can get the count of the number of leap years between the list of two dates in a column using the fill option.

Eg. If the list of start dates are in column B, the list of end dates is in column C, and you need to find the list of counts of leap years in column E for the corresponding start and end dates in the same row, use the same formula explained above and then use the fill option to pull the results across column E. I hope it helps!