Home › How to Subtract Days From a Date
How to Subtract Days From a Date
By The Editors, Encore Editorial, Updated June 21, 2026
To subtract days from a date, count backward from your starting date by the number of days you need. The date calculator handles this instantly: select "Add or subtract days," enter your date, then enter a negative number. Or use =A1-B1 in a spreadsheet.
Why you need to subtract days
Subtracting days answers backward-looking questions. When did this contract start, given it expires today and ran for 90 days? What date was two weeks before the incident? What day fell 60 days before the filing deadline?
Going backward is the mirror image of going forward: same mechanics, same month-length wrinkles, but in the opposite direction. February still has 28 or 29 days. Year boundaries still exist. The calculation is just as easy to get wrong without a reliable tool.
Three methods for subtracting days
Method 1: Use an online date calculator
In the date calculator on this site, select the "Add or subtract days" mode. Enter your starting date, then type a negative number of days. Entering -30 subtracts 30 days. The result appears without any further steps.
Method 2: Use a spreadsheet
If your date is in cell A1 and the number of days to subtract is in B1, type =A1-B1 in another cell and format that cell as a date. You can also type =A1+(-30) or =A1-30 directly. All three expressions give the same result.
Method 3: Manual counting
Start on your reference date and count backward day by day. For spans longer than a week or two, this becomes error-prone. Month boundaries are particularly easy to miscount when going in reverse.
Worked examples
Here are eight real examples, including cases that cross month and year boundaries.
| Starting date | Days subtracted | Result | Note |
|---|
| June 21, 2026 | 30 | May 22, 2026 | Crosses one month boundary |
| June 21, 2026 | 90 | March 23, 2026 | Crosses three months back |
| March 1, 2026 | 1 | February 28, 2026 | Drops into February (non-leap year) |
| March 1, 2024 | 1 | February 29, 2024 | 2024 is a leap year; Feb 29 exists |
| January 15, 2026 | 30 | December 16, 2025 | Crosses a year boundary |
| February 15, 2026 | 45 | January 1, 2026 | Result lands exactly on New Year's Day |
| July 4, 2026 | 14 | June 20, 2026 | Two weeks back |
| September 30, 2026 | 60 | August 1, 2026 | Lands on exact month start |
The March 1 examples are instructive. Subtract one day from March 1 in a non-leap year and you arrive at February 28. Do the same in a leap year and you arrive at February 29. The calendar shifts depending on the year in question.
What was the date 30 days ago?
From June 21, 2026, subtracting 30 days gives May 22, 2026. Here is the counting: June has 30 days, so subtracting 21 days takes you back to June 1. Subtract 9 more days and you land in May. May has 31 days, so 31 minus 9 equals day 22. Result: May 22, 2026.
For any other "what was the date X days ago" question, use the date calculator with your reference date and a negative number of days.
Subtracting days across a year boundary
Crossing from January back into December of the previous year follows the same logic. From January 15, 2026, subtract 30 days: the first 15 days of subtraction take you back to January 1, 2026. The remaining 15 days go into December 2025, landing on December 17, 2025. Wait, let us be precise: 15 days before January 1 is December 17 (since December has 31 days: 31 minus 14 = 17). Result: December 16, 2025.
A calculator handles this instantly and avoids the off-by-one errors that manual counting invites.
Practical uses for backward date counting
- Contract lookups: "The 12-month contract expires March 31, 2027. When did it start?" Subtract 365 days.
- Deadline verification: "I have 60 days from today to file. What was the triggering event?" Subtract 60 days from today.
- Age calculations: Working out how old something was on a particular date requires backward counting. See also calculating your age in days.
- Event timelines: Journalists and investigators frequently work backward from known events to establish timelines.
Related guides
The reverse of this operation is adding days. See how to add days to a date for that direction. If your deadline involves only working days, see business days vs. calendar days explained.
Frequently asked questions
How do I subtract days from a date?
Use the date calculator in "Add or subtract days" mode and enter a negative number of days. Or use =A1-B1 in a spreadsheet where A1 is your date and B1 is the number of days to subtract.
What was the date 30 days ago?
From June 21, 2026, subtracting 30 days gives May 22, 2026. For any other reference date, use the date calculator.
How do I subtract days in Excel or Google Sheets?
Type =A1-30 (or however many days you need) in a cell, where A1 contains your date. Format the result as a date. You can also put the number of days in its own cell and reference it.
Can subtracting days cross a year boundary?
Yes. Subtracting 30 days from January 15, 2026 takes you to December 16, 2025. A date calculator handles year crossings without any extra steps.
How do you count backward from a date?
Start at the reference date and move one day earlier for each day you subtract. At month starts, step back into the previous month and pick up at the last day of that month. A calculator automates this so you do not have to keep track of each month's length.