How to Convert 5-Digit Julian Dates to Regular Dates in Excel. The Julian date format is a five digit number broken into two parts: a two-digit representation of the year followed by a three-digit ...

To ensure that Excel converts your date to a number enter it like this, without quotes: "4/4/2011". Then click on cell "A2" and enter the later of the two dates in the same manner.

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.