TodayFree forever - no sign-up, no paid plans

How to calculate days between dates in Google Sheets

Open the Days Between Calculator

If you already know the Excel formulas, Google Sheets will feel familiar - DATEDIF, NETWORKDAYS and plain subtraction all work here with nearly identical syntax. Sheets adds one genuinely delightful trick of its own: TODAY(), which turns a static count into a living one that updates every morning. This guide covers the core formulas, the TODAY() patterns for days since and days until, and the handful of Sheets quirks that produce strange-looking results.

The simple way: subtraction and DAYS

With a start date in A1 and an end date in B1, the formula =B1-A1 gives the elapsed days between them. March 15, 2026 to June 3, 2026 returns 80, matching the days between calculator exactly. Sheets also offers a purpose-built function, =DAYS(B1,A1) - note the order, end date first - which returns the same number and makes your intent obvious to anyone reading the sheet later.

One formatting note: if the result appears as a date rather than a number, select the cell and apply Format, then Number, then Automatic or Number. Sheets is guessing the format from the inputs, and it guesses wrong in the same way Excel does.

DATEDIF in Sheets

Sheets supports DATEDIF with the same units as Excel: "d" for total days, "y" for whole years, "m" for whole months, "ym" for leftover months and "md" for leftover days. The syntax is =DATEDIF(A1,B1,"d"). For March 15, 2024 to August 20, 2026, the "d" unit returns 888 total days, and combining "y", "ym" and "md" gives the spoken breakdown of 2 years, 5 months and 5 days. As in Excel, keep an eye on the "md" unit around month ends, and remember that DATEDIF errors if the start date is after the end date.

Calculating days between dates in Google Sheets on a laptop with coffee

NETWORKDAYS for working days, holidays included

For business day counts, =NETWORKDAYS(A1,B1) counts Monday to Friday days, and passing a range of holiday dates as the third argument removes them: =NETWORKDAYS(A1,B1,H1:H11). NETWORKDAYS.INTL handles weekends that are not Saturday and Sunday, using the same weekend codes as Excel. The rules underneath - which days count, when the clock starts, why the answer can differ by one from a legal deadline - are covered in our guide on how to count business days between two dates.

Remember that NETWORKDAYS counts both the start and the end date when they fall on weekdays. From Monday, January 5, 2026 to Friday, January 16, 2026 it returns 10, where the elapsed-time method returns 9 business days. Decide which convention your sheet needs before you build reports on top of it.

The TODAY() trick: counts that update themselves

This is where Sheets earns its keep for day counting. =TODAY()-A1 gives the days since the date in A1, recalculated daily - perfect for trackers of subscriptions, streaks, equipment ages and days since an incident. =A1-TODAY() gives the days until the date in A1, which drives countdown columns for deadlines, renewals and events. Our guides on calculating days since a date and calculating days until a date explain the counting rules behind both directions. One caution: TODAY() works at day level, while NOW() includes the time, and subtracting with NOW() produces decimals that look like errors until you spot the fraction.

A worked tracker: days open and days remaining

Here is the pattern in a real shape. Imagine a support team tracking requests in a shared sheet: column A is the request ID, column B the date it arrived, column C the date it was closed, with open requests left blank in C. In column D, one formula handles both cases: =IF(C2="", TODAY()-B2, C2-B2). For a closed request it shows how many days the job took; for an open one it shows how many days it has been waiting, growing by one each morning. Add a column E with =NETWORKDAYS(B2, IF(C2="", TODAY(), C2)) and the same rows report their age in working days, the version a service-level agreement is usually written in.

Two details make this sheet trustworthy rather than merely clever. First, the IF test treats a blank C cell as "still open," so nobody has to maintain the formula as requests close - the formula reads the state of the row itself. Second, sorting by column D descending puts the oldest open requests on top, which turns a passive log into a daily work queue. This is the quiet superpower of spreadsheet day counts over one-off calculator answers: they stay alive, and they keep answering after you have forgotten the question.

The timezone setting nobody checks

One Sheets-specific trap deserves its own warning. TODAY() follows the timezone set for the spreadsheet itself, under File, then Settings - not necessarily the timezone of the person viewing it. A sheet created by a colleague overseas, or from a template set to another region, can tick over to the next day hours before or after your own midnight, so a days-until figure can be one more or one less than a local tool reports, purely because the two disagree about what "today" currently is. If a Sheets countdown and the days between calculator ever differ by exactly one and both formulas look right, check the spreadsheet's timezone before you check anything else. It is the only common day-count error that fixes itself by waiting a few hours.

Sheets quirks worth knowing

Sheets counts days from a zero point of December 30, 1899, one day different from Excel's system, which is why serial numbers for the same date differ by one between the two programs even though date differences agree. Sheets is also aggressive about interpreting typed text as dates - helpful until it converts a part number or a fraction. If a "date" in your sheet refuses to behave, check whether it is really text: a genuine date right-aligns and works in subtraction, while text usually does neither. Finally, locale settings decide whether 03/04/2026 means March 4 or April 3. When a count looks wrong by a few weeks rather than a day, a swapped day and month is the first suspect - a different flavor of the counting mistakes family, and just as fixable once spotted.

Frequently asked questions

Does Google Sheets have NETWORKDAYS?

Yes. NETWORKDAYS works in Google Sheets with the same arguments as Excel: start date, end date, and an optional range of holiday dates to remove. NETWORKDAYS.INTL is also available for weekends that are not Saturday and Sunday.

How do I count days from today automatically in Google Sheets?

Use TODAY(). For days since a date in A1, write =TODAY()-A1. For days until a future date in A1, write =A1-TODAY(). The result recalculates every day, so your sheet always shows the current count.

Why is my date showing as a number like 46000?

You are seeing the date's serial number with number formatting applied. Sheets stores dates as day counts and shows them as dates only when the cell is formatted that way. Select the cell and use Format, then Number, then Date to display it properly.

Can Google Sheets remove holidays from a day count?

Yes, through NETWORKDAYS. Put each holiday date in its own cell and pass the range as the third argument, for example =NETWORKDAYS(A1,B1,H1:H11). Holidays that fall on a weekend are ignored automatically because those days are already excluded.

What is the difference between DAYS and simple subtraction?

Almost nothing in the result - DAYS(end, start) returns the same number as end minus start. The differences are practical: DAYS states your intent clearly, and it ignores any time-of-day fractions, while subtraction on date-times can return decimals that surprise you.

Related guides

How to calculate days between dates in Excel

NETWORKDAYS, DATEDIF and the simple subtraction method, compared.

How to count business days between two dates

Weekends, holidays and the rules banks and employers actually use.

How to calculate days since a date

From birthdays to anniversaries, with the same-day rule explained.

How to calculate how many days until a date

The by-hand method, the spreadsheet method, and the mistakes to avoid.

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.