Google Sheets · Verified tutorial
Verified by JosephineAbout 60 seconds
Sort by date in Google Sheets
Format B2:B4 as dates, then sort A1:B4 by Due date from earliest to latest while keeping the header.
Verified by JosephineAbout 60 secondsQuick answer
Format B2:B4 as dates, then sort A1:B4 by Due date from earliest to latest while keeping the header.
Step-by-step
1
Select the targetFormat B2:B4 as dates.
2
Apply the changesort A1:B4 by Due date from earliest to latest while keeping the header.
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
The rows are ordered Review, Publish, Launch.
Common mistake
Starting with the wrong cell or range selected.
Troubleshooting
Re-select B2:B4 and repeat the final action. The rows are ordered Review, Publish, Launch.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Task | Due date |
| Launch | 46265 |
| Review | 46235 |
| Publish | 46249 |
Video transcript
- Open the prepared Practice spreadsheet.
- Select the target. Format B2:B4 as dates.
- Apply the change. sort A1:B4 by Due date from earliest to latest while keeping the header.
- The rows are ordered Review, Publish, Launch.