New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Spreadsheet basics›Create a date series

Google Sheets · Verified tutorial

Create a date series in Google Sheets

Format A2 as a date, then create a daily date series from August 1 through August 4, 2026 in A2:A5 using autofill.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Format A2 as a date, then create a daily date series from August 1 through August 4, 2026 in A2:A5 using autofill.

Step-by-step

1

Select the targetFormat A2 as a date.

2

Complete the next actioncreate a daily date series from August 1 through August 4, 2026 in A2:A5.

3

Apply the changeautofill.

Shortcut or faster method

Use the menu path shown in the video and keep the target range selected until the change is applied.

Expected result

A2:A5 contains four consecutive dates.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select A2 and repeat the final action. A2:A5 contains four consecutive dates.

Example spreadsheet data

This is the clean fixture used for the verified run.

Date

46235

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Format A2 as a date.
Complete the next action. create a daily date series from August 1 through August 4, 2026 in A2:A5.
Apply the change. autofill.
A2:A5 contains four consecutive dates.