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.

Between the 2003 and the most recent versions, the number of rows that can be reached in an Excel sheet has changed significantly. As a result, the VBA codes prevent the portability of your workbook ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

Click on the column header to select the location for your date information. In the Home tab on the Excel ribbon, click on the arrow at the bottom right corner of the Number section.

Excel provides one general formula that finds the difference between numbers, dates and times. It also provides some advanced options to apply custom formats to your results.

Either way, counting the number of records that fall between two dates is easy using the COUNTIFS () function (which isn’t available in Excel 2003 or earlier).