How to Convert Dates to Years in Excel. When you use Microsoft Excel to store and analyze business data, your workbooks and worksheets often contain date information. Although your original data ...

If you need to count or calculate number of Leap Years between two dates in Excel or list of two dates in Excel, make use of this formula to get things done.