Google Sheets Date Formula Today Minus Date

If you track last contact dates, you probably need to know how many days have passed. Google Sheets can subtract a stored date from TODAY and keep the result current. This guide shows the formula for follow-up and retention lists.

Formula Syntax

Use this base syntax for google sheets date formula today minus date and replace the ranges with your own spreadsheet columns. 

TODAY() - date_cell

Need this formula for your exact sheet?

Generate a custom google sheets date formula today minus date formula with your own columns, criteria, and spreadsheet layout.

Generate Free Formula

Step-by-step Example

A revenue operations spreadsheet tracks Days since last contact and needs a formula-driven result instead of manual filtering.

Customer Last Contact
Acme 2026-05-20
Beta Co 2026-05-25
Cedar 2026-04-30

Resulting formula

=TODAY()-B2

The formula evaluates the Days since last contact rows and returns Days elapsed. Replace the sample ranges with your actual columns, then adjust the criteria so the result matches your workbook.

Try It Now

The generator is pre-filled for google sheets date formula today minus date. Edit the prompt to match your columns, criteria, and spreadsheet layout.

You can write your request in any language. Excel formula language is selected separately.

Auto (detect from browser)

Available after free registration Sign up free

C

Available after free registration Sign up free

2

Available after free registration Sign up free

Security check required. Please complete the captcha below.

Works with SUMIFS, IF, XLOOKUP, dates, text, arrays…

Generated formula

How it works

Need more formulas every day?

HelpFormula Pro is $7.99/mo for faster spreadsheet work across Excel and Google Sheets.

  • ✓ Higher daily formula generation limits
  • ✓ Saved formula history for reuse
  • ✓ Excel formula language selection
Upgrade to Pro — $7.99/mo Sign Up Free

Common Variations

  • Days since a date
  • Ignore blank dates
  • Flag stale records

FAQ

How do I set up Google Sheets Date Formula Today Minus Date for Days since last contact?

Map the sample columns to your own sheet first, then replace the formula ranges with the real ranges from your workbook. Keep text criteria in quotes and verify that date or number columns are stored as real values.

Can this formula handle days since a date?

Yes. Use the same formula pattern and change the criteria, helper column, or lookup value for days since a date. If the logic becomes more complex, generate a custom version with the free tool.

What should I check if the Google Sheets Date Formula Today Minus Date result is wrong?

Check that every referenced range covers the same rows, locked references use dollar signs where needed, and the criteria type matches the data. For this page, also confirm that the Days since last contact fields are formatted consistently.