How To: Extract & List All Dates Between Two Dates in Microsoft Excel

Updated December 2023: Stop getting error messages and slow down your system with our optimization tool. Get it now at this link
  1. Download and install the repair tool here.
  2. Let it scan your computer.
  3. The tool will then repair your computer.

In some cases, if you have the specific start and end dates, you may need to list all the data between these two dates in Microsoft Excel. This tutorial covers methods to list all data between two dates in Excel.

How can I extract all records between two data in Excel?

Basic date ranges

You can create a formula or use an integrated function to create date ranges, read on to learn more.

Now you know that the data are numbers in Excel. You can easily create a date range by adding a number to a date.

The following image shows a start date of 15/11/2017, where the number 7 is added to this date, 22/11/2017.

This way, you can quickly create date ranges by simply adding a number to a date.

  1. Now select cell B4 and enter =C3+1
  2. Copy cell C3 and paste it into cell C4.
  3. The cell references change when you copy a cell and paste it into a new cell, and I will use it now.

December 2023 Update:

You can now prevent PC problems by using this tool, such as protecting you against file loss and malware. Additionally it is a great way to optimize your computer for maximum performance. The program fixes common errors that might occur on Windows systems with ease - no need for hours of troubleshooting when you have the perfect solution at your fingertips:

  • Step 1 : Download PC Repair & Optimizer Tool (Windows 10, 8, 7, XP, Vista – Microsoft Gold Certified).
  • Step 2 : Click “Start Scan” to find Windows registry issues that could be causing PC problems.
  • Step 3 : Click “Repair All” to fix all issues.


Create a list of sequential appointments in Excel with the fill handle.

Microsoft Excel has a filling handle that makes it easy to create a list of consecutive data. Although this does not help with data between two given dates, using this option is much easier than using the formula.

  1. Simply enter the date in cell A1 and click somewhere outside the cell. Then click on the cell again to activate the filling handle.
  2. Drag the fill handle down to create a list of sequential appointments in Excel.
  3. Select the cell that contains the first date. Drag the Fill handle onto the adjacent cells you want to fill with sequential data.
  4. Select the filling handle in the lower right corner of the cell, hold it down and slide it to fill the rest of the series. The filling handles can be slid up, down or on a spreadsheet.

Use the Fill command.

  1. Select the cell with the first date. Then select the range of cells you want to fill.
  2. Select Home > Edit > Fill > Series > Date unit. Select the desired unit.

Expert Tip: This repair tool scans the repositories and replaces corrupt or missing files if none of these methods have worked. It works well in most cases where the problem is due to system corruption. This tool will also optimize your system to maximize performance. It can be downloaded by Clicking Here