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

RECOMMENDED: Click here to fix Windows errors and optimize system performance

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.

January 2021 Update:

We now recommend using this tool for your error. Additionally, this tool fixes common computer errors, protects you against file loss, malware, hardware failures and optimizes your PC for maximum performance. You can fix your PC problems quickly and prevent others from happening with this software:

  • 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.

RECOMMENDED: Click here to troubleshoot Windows errors and optimize system performance