Dates & time
Shift a list of dates
Move dates by days or calendar months while preserving their input order.
A clear answer. Here’s how.
Shifts each of up to 10,000 dates independently. Calendar months keep the source day where it exists; otherwise the selected clamp/reject policy applies. Day shifts use fixed calendar dates. Retains duplicates and input order, adds the day-of-week label, and rejects dates outside years 0001–9999.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- One YYYY-MM-DD date per line
2024-01-31 2024-02-29 2024-03-31
- Shift unit
- Calendar months
- Signed shift
- 1
- Missing target day
- Use the target month’s last day
Example result
| Original | Shifted | Result weekday |
|---|---|---|
| 2024-01-31 | 2024-02-29 | Thursday |
| 2024-02-29 | 2024-03-29 | Friday |
| 2024-03-31 | 2024-04-30 | Tuesday |