# How to list all dates between two dates in Excel

Use SEQUENCE starting at the start date: `=SEQUENCE(B2-B1+1,1,B1)`, and format the results as dates.

**Excel:** `=SEQUENCE(B2-B1+1,1,B1)` (Excel 2021, 2024 and Microsoft 365)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D |
| --- | --- | --- | --- |
| Start | 2026-03-27 |  | Dates |
| End | 2026-04-03 |  |  |

Formula in D2: `=SEQUENCE(B2-B1+1,1,B1)`

Result (spills 8 × 1): 3/27/2026; 3/28/2026; 3/29/2026; 3/30/2026; 3/31/2026; 4/1/2026; 4/2/2026; 4/3/2026

## How it works

SEQUENCE(rows, columns, start) counts up from the start date one day at a time. `B2-B1+1` is the number of days including both ends, so the list stops on the end date. Format the spill range as dates.

## Other ways

- `=B1+SEQUENCE(B2-B1+1,1,0)`: Adds 0, 1, 2 … days to the start date.

## Common mistakes

- Without a date format the list shows serial numbers like 46108.
- Older Excel has no SEQUENCE: type the start date, put `=D2+1` below it and fill down.

## Questions

**How do I list only weekdays?**

`=WORKDAY(B1-1,SEQUENCE(NETWORKDAYS(B1,B2)))`.

**How do I list one date per week?**

Give SEQUENCE a step of 7: `=SEQUENCE(INT((B2-B1)/7)+1,1,B1,7)`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/list-all-dates-between-two-dates