Excel Subtract Date from TODAY

What this does

Excel and Google Sheets have no SUBTRACT function because the minus sign already does the job: any formula that starts with = can subtract one cell or number from another. To subtract several values at once you can chain them (=A2-B2-C2) or subtract a SUM (=A2-SUM(B2:B10)), which is tidier when the list is long. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. For “excel subtract date from today”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. That is what makes a workflow that saves repeating the same clicks every week useful in real work: repeatable, auditable, and not dependent on memory or luck.

A worked example

To take expenses of 120 away from revenue of 500, type =500-120 (or =A2-B2 pointing at the two cells) and press Enter — the result is 380. To subtract a whole column of costs from a budget in B1, use =B1-SUM(B2:B20). Negative results display with a minus sign automatically. Subtraction is the quiet backbone of every variance, margin and running-total formula. Knowing there is no function — only the operator — saves you hunting for one and lets you build differences directly. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.

In Google Sheets

Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. Treat “excel subtract date from today” as a small building block rather than a chore. Once the inputs sit in their own cells and the formula reads from them, the same setup answers a dozen related questions with a tweak, and Excel keeps every dependent figure current as the data changes. The tool above is there so you can rehearse and verify before committing anything to a real workbook; the steps and worked example are there so the logic sticks. Get it right once and it stops costing you time — it starts saving it, every time the question comes back around.

Common mistakes

• Looking for a SUBTRACT function — there is none; the − operator is the answer.
• Forgetting the leading =, so the sheet treats the entry as text.
• Subtracting cells that contain text or are blank, which can return errors or unexpected zeros.
• Mixing up the order — A2-B2 and B2-A2 differ by a sign.

Frequently asked questions