TodayFree forever - no sign-up, no paid plans

How to subtract days from a date

By Daniel Mercer · Updated October 31, 2026

Open the Date Calculator

Counting backward is where date arithmetic earns its bad reputation. You subtract days from a date whenever a deadline, a moving day, a payment date or a filing date is fixed and the preparation has to start earlier - and the count crosses month ends in the direction your brain handles worst. This guide gives you the mirror image of the forward method, three worked examples, and the forward check that proves your answer.

The rule, reversed

Forward counting treats the start date as day zero and counts the midnights you cross. Backward counting uses exactly the same rule in the other direction: the date you start from is still day zero, so subtracting 1 day from a Friday lands on Thursday, and subtracting 7 days lands on the Friday of the week before. Our date calculator follows this rule when you choose Subtract, and so do contracts, cooling-off periods and return windows.

The one thing that changes when you reverse is which month length you borrow. Counting forward out of March, you care that March has 31 days. Counting backward into May, you care that May has 31 days - the length of the month you are landing in, not the one you are leaving. Most backward-counting errors are just this swap done wrong.

Worked example 1 - packing backwards from moving day

Your lease starts on Tuesday, June 30, 2026, and you want to start packing 45 days before. What date is 45 days before June 30?

StepDays usedDays left to countYou are now at
Count back to the start of June (30 - 0, the whole month back to May 31)3045 - 30 = 15May 31, 2026
Count 15 more days back into May150May 16, 2026

Packing starts on Saturday, May 16, 2026. Now prove it with the forward check: May 16 plus 45 days. May has 31 days, so 15 days take you to May 31, and 30 more take you to June 30. You land exactly where you started, so the backward count is right. If you only ever learn one habit from this page, make it this one: every backward count gets a forward check. It takes ten seconds and catches nearly every slip.

How to subtract days from a date - packed moving boxes counted back from moving day

Worked example 2 - crossing the New Year backward

A payment is due on January 15, 2027, and the paperwork must be filed 30 days earlier. January counts back quickly: 15 days take you to December 31, 2026, using half the count. The remaining 15 days run back through December, which has 31 days, so you land on Wednesday, December 16, 2026. Year boundaries feel dramatic but change nothing about the method - December is just the previous month, with 31 days like any other 31-day month.

Worked example 3 - a short count from today

From today, Sunday, November 22, 2026, the backward spans people ask about most are these. Whole weeks keep the weekday, which makes them easy to check at a glance.

SubtractResulting dateWeekday
7 daysNovember 15, 2026Sunday
14 daysNovember 8, 2026Sunday
30 daysOctober 23, 2026Friday
45 daysOctober 8, 2026Thursday
90 daysAugust 24, 2026Monday

For a span of 100 days or more, or any count you cannot afford to get wrong, run it through the date calculator and read the weekday it reports - the weekday is the fastest lie detector in date arithmetic, because a wrong month length almost always shifts it. And if what you really need is the gap between two fixed dates rather than a count back from one of them, the days between calculator on the homepage answers that directly.

The mistakes that only happen backward

Using the wrong month's length. Counting back from June 30 into May, people reach for June's 30 days. The days you are walking through belong to May, and May has 31. Always price the month you are standing in.

Counting the start day. Pointing at the start date and calling it "one" makes every backward answer one day too late - the mirror image of the forward mistake, and just as common.

Trusting the rough month. Treating every month as 30 days drifts a long backward count by a day for every 31-day month crossed. Over a 90-day count that is often a 3-day error, which is the difference between a filing that is early and one that is late.

Skipping the forward check. A backward count that is never checked forward is a guess with good handwriting. Add the days back; if you do not land on your starting date, the count is wrong and now you know it before it matters.

In a spreadsheet

Excel and Google Sheets store dates as day numbers, so subtraction is plain arithmetic: =A1-45 subtracts 45 days from the date in cell A1. Two warnings. First, if the result shows as hash symbols, widen the column before you panic. Second, subtracting a large number from an early date can push the result before the spreadsheet's earliest supported date, which produces an error rather than a date - a sign the count itself needs a second look.

A note on cooling-off periods and return windows

Backward counts show up most often in consumer life as cooling-off periods and return windows, and both hide a small trap: the clock usually starts on the day after delivery or signing, not the day of it, and the last day of the window is counted in full. A 14-day window that opens the day after a Monday delivery therefore closes on the Monday two weeks later, not the Sunday. When real money rides on the answer, read the exact wording of the window - "within 14 days of delivery" and "14 days from delivery, counting the delivery day" are different windows that end a day apart.

Frequently asked questions

Does the start date count when subtracting days?

No. The date you start from is day zero, so subtracting 1 day from a Friday gives Thursday. This matches how deadlines and cooling-off periods are counted. If someone counts the start day itself, their answer will be one day later than yours.

What is 45 days before June 30, 2026?

May 16, 2026. Count back 30 days to reach May 31, then 15 more days into May, which lands on May 16. Checking forward confirms it: May 16 plus 45 days is June 30.

How do I subtract days from a date in Excel?

Use plain subtraction: =A1-45 subtracts 45 days from the date in cell A1. If the result shows as a row of hash symbols, the column is too narrow or the result is a negative date, which happens when you subtract more days than the date can give.

How can I check a backward count?

Add the same number of days to your answer. If you land back on the date you started from, the backward count was right. This forward check catches almost every slip, especially the ones caused by using the wrong month length.

Can I subtract business days instead?

Yes. Counting business days backward skips weekends and usually holidays, so a 10-business-day deadline reaches further back on the calendar than a 10-calendar-day one. Use the business days calculator or the WORKDAY function with a negative number in a spreadsheet.

Related guides

How to add days to a date

The forward method, with worked examples that cross month ends and the New Year.

How to find the date 100 days ago

A longer backward count, plus the day-of-year shortcut for checking it.

Counting forward vs counting backward - common date mistakes

Why the two directions fail in different ways, and how to catch both.

How to calculate the date 45 days from now

The 45-day forward count, step by step, from any start date.

Daniel Mercer

Daniel Mercer builds and maintains the calculators on this site. He spent ten years in payroll and operations roles counting business days, notice periods and deadlines by hand, and writes these guides the way he would explain the count to a colleague - the rule first, a worked example second, and the common mistake called out before it happens.