# How to create a list of dates with a formula in Excel

Use SEQUENCE with the start date as its start: `=SEQUENCE(B2,1,B1,1)` lists `B2` consecutive dates from the date in `B1`. Format the cells as dates.

**Excel:** `=SEQUENCE(B2,1,B1,1)` (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-07-06 |  | Date |
| Days | 14 |  |  |

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

Result (spills 14 × 1): Jul 6, 2026; Jul 7, 2026; Jul 8, 2026; Jul 9, 2026; Jul 10, 2026; Jul 11, 2026; Jul 12, 2026; Jul 13, 2026; Jul 14, 2026; Jul 15, 2026; Jul 16, 2026; Jul 17, 2026; Jul 18, 2026; Jul 19, 2026

## How it works

SEQUENCE takes rows, columns, start and step. A date is a number underneath, so starting at the date in `B1` with a step of 1 gives one date per day. The cells need a date format, otherwise the dates show as serial numbers such as 46209.

## Other ways

- `=B1+SEQUENCE(B2)-1`: Adds 0, 1, 2 and so on to the start date. Same list.
- `=SEQUENCE(B2,1,B1,7)`: A step of 7 gives the same weekday every week, for a weekly schedule. (Fourteen Mondays, one week apart.)

## Common mistakes

- Without a date format the result looks like 46209, 46210 and so on. Format the spill area as a date.
- Typing the date inside SEQUENCE as text, `SEQUENCE(14,1,"7/6/2026")`, depends on regional settings. Keep the start date in a cell.

## Questions

**How do I list every date between two dates?**

Work out the count from the two dates: `=SEQUENCE(B2-B1+1,1,B1)` with the end date in B2.

**How do I list dates across a row instead of down a column?**

Swap rows and columns: `=SEQUENCE(1,B2,B1,1)`.

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/create-a-list-of-dates