How to List All Dates Between Two Dates in Excel

If you need to list all dates between two specific dates in Excel, you can do so using a simple formula. This is how you do it:

Step 1: Input Your Start and End Dates

First, in two separate cells, enter your start date and end date. For example, you might enter 1/1/2023 in cell A1 and 1/31/2023 in cell B1.

Step 2: Use the SEQUENCE Function

Next, go to the cell where you want your date list to begin, let's say A3. Enter the following SEQUENCE function: =SEQUENCE(B1-A1+1,1,A1,1). This formula will generate a vertical list (column) of dates.

Step 3: Format the Cells as Dates

To ensure that Excel recognizes and displays the list as dates, highlight the cells and go to the Home tab. In the Number group, select Short Date or Long Date from the dropdown menu.

Step 4: Check the Results

Finally, confirm that Excel has correctly listed all dates between your two specified dates.