Dates not sorting correctly in Google Sheets
The dates are in the wrong order. Reorder the complete rows so the ISO dates in A2:A4 run oldest to newest. Keep each event paired with its date.
Verified by JosephineAbout 75 secondsThe dates are in the wrong order. Reorder the complete rows so the ISO dates in A2:A4 run oldest to newest. Keep each event paired with its date.
Step-by-step
Select the targetThe dates are in the wrong order.
Complete the next actionReorder the complete rows so the ISO dates in A2:A4 run oldest to newest.
Apply the changeKeep each event paired with its date.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
The date rows are ordered February, July, then December.
Common mistake
Starting with the wrong cell or range selected.
Troubleshooting
Re-select A2:A4 and repeat the final action. The date rows are ordered February, July, then December.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Date | Event |
| 2026-12-01 | Renewal |
| 2026-02-15 | Planning |
| 2026-07-25 | Launch |
Video transcript
- Open the prepared Date repair spreadsheet.
- Select the target. The dates are in the wrong order.
- Complete the next action. Reorder the complete rows so the ISO dates in A2:A4 run oldest to newest.
- Apply the change. Keep each event paired with its date.
- The date rows are ordered February, July, then December.