The launch slipped by ten days, and suddenly every date on your plan moved — the kick-off, the review, the delivery, the follow-up. You could open the sheet and change each one by hand, but that is exactly how one row gets missed and a deadline quietly stays in the past. When you need a date list shifter, this free tool does the whole list at once: paste your dates, pick how far they move and in which direction, and get the shifted list back in the same order, ready to paste back.
| # | Original | Shifted |
|---|
Invalid lines — not shifted
Nothing is uploaded. Dates stay in your browser, and ambiguous slash dates are read day-first.
How the date list shifter works
Paste your dates into the box, one per line. They can come straight from a spreadsheet column — copy the column, paste it here, and you are done. Then set the shift, choose forward or back, and pick the output format you want.
Press “Shift Dates” and the tool reads each line in turn. Every line it can read becomes a new date, and every line it cannot read is flagged below the results, with its line number, so you can fix it and run the list again. Nothing is uploaded, so a course plan or a client schedule never leaves your browser.
Shifting by days, weeks or months
Days are the usual pick when a launch slips by a fixed number of days, or a holiday pushes a set of bookings along. Weeks suit a course term that moves by a whole week, or a rota that starts a week later than planned. Months suit a payment plan or a project phase that rolls on by a calendar month.
The amount box takes a whole number, so 10 days, 2 weeks and 3 months are all as easy as each other. Direction matters just as much: forward moves every date later, back pulls every date earlier, and the same amount and unit apply to the whole list, so the gaps between your dates stay exactly as they were.
Move a whole list of dates at once
Paste the list and the shifter moves every date by the same number of days, weeks or months, keeping the original order for pasting back. Month-end dates clamp to the last day of the month, and leap years are handled.
Month-end and leap-year handling
Adding a month is not the same as adding 30 days, and the tool treats it that way. It moves the month on by one and keeps the day where it can, so 15 January plus one month is 15 February. When the day does not exist in the new month, it clamps to the last day of that month instead of spilling into the next one.
That is why 31 January shifted by one month becomes 28 February in an ordinary year and 29 February in a leap year. The same rule runs in reverse: 31 March shifted back by one month lands on 28 or 29 February, and 29 February 2028 shifted forward by 12 months lands on 28 February 2029. Leap days are real dates here, not a rounding error, and the tool checks each shifted date against the calendar before it shows it to you.
Worked example: a 6-date project list, moved 10 days forward
Say your project list looks like this, in YYYY-MM-DD format:
2026-11-022026-11-052026-11-092026-11-122026-11-162026-11-20
Load the example in the tool, keep the shift at 10 days and the direction on forward, then press “Shift Dates”. The tool reports 6 dates shifted, and the shifted list reads 2026-11-12, 2026-11-15, 2026-11-19, 2026-11-22, 2026-11-26 and 2026-11-30. The gaps are untouched — three days, four days, three days, four days, four days — because every date moved by the same ten days.
Copy the shifted list and paste it back over the old one. If one line in your real list is typed wrong, it will sit in the invalid list below the table, while the other dates still shift, so a single typo never costs you the whole run.
Keeping the original order for pasting back
Order is the whole point of a list tool. The tool never sorts your dates, never drops a row to make the list tidy, and never fills a gap you did not ask it to fill. The first date you paste is the first date you get back, and the last is the last, even if your list is not in date order to start with.
That matters when the list is not really a calendar at all, but a set of steps in a fixed order — a training plan, a set of invoice dates, a run of appointments. Paste the shifted list straight back into the same column, and each new date lands on the same row its old date came from. Check the count in the summary first: if it says 6 dates shifted and you pasted 6, you know nothing went missing on the way.
Related date tools
Before you shift a list, it helps to know the list is clean. If your dates arrive in a jumble of formats, the Messy Date Cleaner sorts the formats out first, so this shifter can read every line. And once your list is complete, the Bulk Days-Until / Days-Since List tells you how many days are left until — or have passed since — every date in the list, all at once.
If a date has gone missing from a run altogether, the Missing Dates in a List Finder spots the gap before you shift the rest.
Frequently asked questions
What happens to 31 January shifted by a month?
It clamps to the last day of February: 31 January 2026 plus one month becomes 28 February 2026, and 31 January 2028 plus one month becomes 29 February 2028, because 2028 is a leap year. The tool never rolls the extra days into March, so the shifted date stays in the month you asked for.
Can I shift backwards?
Yes. Choose Back as the direction, set the same amount and unit, and every date moves earlier by that amount. Month-end clamping still applies in reverse, so 31 March shifted back by one month lands on 28 February in an ordinary year and 29 February in a leap year.
Which date formats are accepted?
The tool reads YYYY-MM-DD and YYYY/MM/DD, day-first slash dates such as 02/11/2026, month-first dates such as 11/02/2026 when the day is over 12, and month names such as 12 Nov 2026 and Nov 12, 2026. A slash date where both numbers are 12 or under is read day-first, so use YYYY-MM-DD when you want a date to be read without any doubt.
Are invalid lines dropped or flagged?
They are flagged, never dropped without a trace. A line the tool cannot read is listed below the results with its line number and its text, while the dates it could read still shift as normal. Fix the flagged lines, paste the list again, and run it once more.
How do I shift all dates in Excel at once?
Paste the list here instead of writing a formula, and the shifter moves every date by the same amount, in days, weeks or months. The order stays the same, so the result pastes straight back into your sheet.
Do I need to sort my dates before shifting them?
No. The shifter moves each date by the same amount and keeps the original order, so the list comes back in the same order it went in. Invalid lines are flagged instead of dropped, so nothing is lost.
Nothing is uploaded. The whole shift runs in your browser, so your dates never leave your device.