How to Add or Subtract Days From a Date
If you need to figure out what date falls 60 days from today, or work backwards from a deadline to find when you should start, you're asking one of the most practical questions in time management: how do I add or subtract days from a date? The good news is it's simple. The better news is that a calculator does it in seconds.
The bad news? When you're doing it manually, it's surprisingly easy to lose count after the second month, especially if you're juggling February's weird length or remembering which months have 30 vs 31 days. This guide covers both how to do it and why it matters more than you'd think.
Why Adding or Subtracting Days Matters
The reason this is important isn't abstract — it's about real deadlines and real consequences.
Say your report is due 15 May, but it needs 3 days of review before submission. Your draft deadline is 12 May — which happens to be a Friday. If your team isn't in the office weekends, you actually need to deliver it Thursday 11 May. Now work backwards: if writing the draft takes 5 working days, you need to start by Monday 4 May. But your colleagues are slow with feedback (let's say 2–3 days), so you're really starting at late April. That "mid-May deadline" has just compressed into early May.
This is why precision matters. A vague "we have loads of time" collapses when you add or subtract days properly and realise you've got 2 weeks, not 4.
For more complex scheduling — when multiple deadlines and milestones overlap — see our guide on date calculations for project management. The principle is the same: add or subtract days, work backwards, find your real start date.
How to Add or Subtract Days From a Date
Mathematically, this is straightforward: pick a start date, add (or subtract) the number of days, and you have your answer.
Example of adding:
- Start: 1 May 2026
- Add: 30 days
- Result: 31 May 2026
Example of subtracting:
- Start: 1 May 2026
- Subtract: 30 days
- Result: 1 April 2026
The catch: you have to remember that April, June, September, and November have 30 days; the rest have 31. February is 28 (or 29 in a leap year). Do this in your head, and most people lose track halfway through a second month.
That's why a date calculator exists. Enter your start date, pick add or subtract, type the number of days, and get the answer in seconds. No mental arithmetic, no month-length confusion, no risk of landing on the wrong date.
Working Days vs Calendar Days: The Gotcha
Here's the mistake that catches everyone: a deadline 30 days away is not 30 working days.
Calendar days include weekends. Working days (Monday–Friday) are roughly 5 out of every 7. So 30 calendar days is about 21–22 working days — a 28% difference.
Add UK bank holidays, and the gap widens further. If your project spans late April to late May, you'll hit the Early May Bank Holiday (5 May 2026) and Spring Bank Holiday (25 May 2026). That's 2 extra days off your working-day count. Your "30 calendar days" is now only about 20 working days. Check gov.uk's bank holiday calendar to see which dates are coming up.
Always clarify with your team: is the deadline in calendar days or working days? "We need it in 4 weeks" could mean 28 calendar days (4 × 7) or 20 working days (4 × 5). The difference is the difference between comfy and panicked.
Common Use Cases for Adding or Subtracting Days
Wedding Planning
You have a date. Now work backwards. Invitations go out 8–12 weeks before (add 56–84 days). Catering deposits are usually due 6 weeks prior (add 42 days). Final headcount goes to the venue 2 weeks before (add 14 days). Each is a date calculation. Miss one, and you're scrambling. Our wedding countdown guide walks the full timeline with all the dates that actually matter.
Exam Revision
Your exam is 15 June. How many days to revise starting now? Subtract today from 15 June. Let's say you have 40 days. If you're revising 5 subjects, that's 8 days per subject. If you want a full week of rest before the exam, subtract 49 days from the exam date — that's your true start date. Our exam countdown tracker shows you exactly how much runway you have and helps you divide your time across topics.
Holiday Countdowns
How many days until your trip? Subtract today from your departure date. This forces you to confront that you need to book accommodation sooner, arrange transport, sort pet care, or pack — not "eventually," but this week. People routinely underestimate how fast countdowns go. Precise arithmetic has a way of sharpening focus. Our holiday countdown guide explores the full planning timeline.
Project Milestones
Your project started 1 January. Milestones hit at day 30, 60, and 90. That's 31 January, 1 March, and 2 April. Across long projects, these date calculations prevent milestone dates from drifting. You can calculate days between two dates to find gaps, or work forwards from a start date to pin down exactly when each milestone lands.
Age and Life Events
When will you turn 30? How old will you be on a specific date? These are additions to your birth date, sometimes with subtraction for precision. You can calculate your exact age down to the day — useful for visa eligibility, financial milestones, or personal curiosity about how many days you've been alive.
Retirement and Financial Planning
If you plan to retire 1 March 2045, how many working days is that from today? How many contribution years remain? These are date subtractions that shape your financial plan.
Tools to Add or Subtract Days Instantly
You have options:
- Our date calculator — enter a start date, choose add or subtract, enter the number of days, get the result instantly with no thinking required
- Excel or Google Sheets —
=A1+30adds 30 days;=A1-14subtracts 14 days (make sure the cell is formatted as a date) - Days between calculator — if you know two dates but not the gap, this calculates the exact number of days
- Date countdowns — for upcoming events, count down to the minute
For complex scenarios — multiple dates, working days only, accounting for holidays — our full calculator suite has tools for virtually every scenario.
Frequently Asked Questions
Q: How do I add days to a date in Excel or Google Sheets?
A: Use simple arithmetic: =A1+30 (where A1 is a date cell) adds 30 days to that date. =A1-14 subtracts 14 days. The cell needs to be formatted as a date, not text or general number. If the result shows as a number instead of a date, right-click the cell, select "Format cells," and choose "Date."
Q: What's the difference between adding 30 days and adding 1 month? A: Adding 30 days is fixed — always 30 calendar days. Adding "1 month" is ambiguous because months vary (28–31 days). For precision, use days. May 1 + 1 month = June 1 (always). May 1 + 30 days = May 31 (always). When planning, specify days, not months.
Q: If I add 7 days, do I get the same day of the week? A: Yes, always. Days of the week repeat every 7 days. Add 7 days to Monday and you get Monday. Subtract 14 days from Friday and you get Friday. This is handy for scheduling recurring tasks or weekly milestones.
Q: Do I need to think about leap years? A: No. A leap year has 366 days instead of 365, but a proper calculator or spreadsheet handles leap years automatically. February 28, 2024 + 1 day = February 29, 2024 (leap year). February 28, 2025 + 1 day = March 1, 2025 (no leap year). No manual adjustment needed.
Q: Can I add or subtract days from dates in the past? A: Absolutely. Want to know what date was 365 days ago? Subtract 365 from today. Curious what day you were born plus 10,000 days was? Add 10,000 to your birth date. The math works in both directions.
Q: What if my deadline includes weekends or bank holidays? A: This is where most plans go wrong. If someone says "30 days," ask: calendar days or working days? Then check gov.uk's bank holiday calendar to see if public holidays fall in your window. Subtract them from your working-day count to get your realistic deadline.
Q: How far back or forward can I calculate? A: As far as you need. Our calculators handle dates years into the future or decades into the past. For planning and scheduling in the 21st century, you're covered.