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

Google Sheets tutorials›Formatting›Format dates

Google Sheets · Verified tutorial

Format dates in Google Sheets

Format A2:A4 as dates using the standard date format.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Format A2:A4 as dates using the standard date format.

Step-by-step

1

Select the targetFormat A2:A4 as dates.

2

Apply the changethe standard date format.

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:A4 uses a DATE number format.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select A2:A4 and repeat the final action. A2:A4 uses a DATE number format.

Example spreadsheet data

This is the clean fixture used for the verified run.

Date

46115

46145

46175

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Format A2:A4 as dates.
Apply the change. the standard date format.
A2:A4 uses a DATE number format.