Google Sheets handles date arithmetic almost identically to Excel - the same formulas, the same answers, the same serial numbers underneath. The differences that bite are not in the formulas but around them: locale settings that change what a typed date means, and a timezone setting that decides when "today" rolls over. This guide covers the formulas first, then those two traps.
The formulas
Like Excel, Sheets stores a date as a day count, so adding days is plain arithmetic. If cell A1 holds a departure date of November 22, 2026 and you want the date 45 days later - a visa check date, a follow-up, a return deadline - the formula is =A1+45, and the answer is January 6, 2027. The full toolkit mirrors Excel's:
| Job | Formula |
|---|---|
| Add or subtract days | =A1+45 or =A1-45 |
| Count from today | =TODAY()+30 |
| Add months (with month-end clamping) | =EDATE(A1,3) |
| Add business days, skipping weekends and holidays | =WORKDAY(A1,10,holidays) |
| Count days between two dates | =B1-A1 or =DATEDIF(A1,B1,"D") |
For a one-off calculation with no spreadsheet open, our date calculator does the same work and shows the weekday of the answer, and the days between calculator on the homepage counts the gap between two dates directly.

Trap 1 - the locale decides what your typed date means
Sheets reads typed dates through the spreadsheet's locale, found under File, then Settings. In a United States locale sheet, typing 02/03/2026 gives February 3, 2026. In a United Kingdom locale sheet, the same keystrokes give March 2, 2026. Both are "correct" - and a shared sheet edited from two countries can quietly hold both interpretations in different rows. The defence is to build fixed dates with the DATE function: =DATE(2026,2,3) takes year, month and day as three separate numbers and means February 3 in every locale on earth. Use it for any date a formula depends on - contract starts, deadlines, birthdays - and reserve typed dates for quick one-off entries you will eyeball immediately.
Trap 2 - TODAY() follows the sheet's timezone, not yours
The TODAY and NOW functions take their sense of "now" from the spreadsheet's timezone setting, not from the device of whoever is viewing. A sheet set to a timezone several hours behind yours will roll to the next day later than your wall clock does, and a countdown formula like =A1-TODAY() can sit one day off for viewers in other regions - correct in the sheet's timezone, wrong on their wall. For shared sheets with deadlines in them, either set the timezone deliberately and note it on the sheet, or anchor countdowns to a typed date cell that a human updates. It is a small setting that explains a large share of "the spreadsheet says tomorrow" arguments.
Formatting, and the number that is secretly a date
If a formula result appears as a long number - 46393, say - the value is right and the format is wrong. Dates in Sheets are stored as serial day counts (November 22, 2026 is 46348, matching Excel's serial for the same date), and a cell formatted as a plain number shows the serial instead of the date. Apply a date format from the Format menu to fix the display; the underlying value never changes. The opposite problem is a typed entry Sheets did not recognise as a date at all, which stays left-aligned text and breaks formulas with #VALUE errors. Re-enter it in your locale's format, or rebuild it with DATE, and the arithmetic starts working.
Two Sheets behaviours that catch people out
TODAY() never sits still. A formula built on TODAY() recalculates every day, which is perfect for a live tracker - "days until the renewal" shrinking as you watch - and wrong for a record. A completion date computed as =TODAY()+30 will quietly move tomorrow, rewriting history. When a calculated date becomes a fact, freeze it: copy the cell and paste it back as values only, so the date stays the date.
Your locale decides what you typed. Sheets interprets typed dates using the spreadsheet's locale setting. In a US-locale sheet, 03/04/2026 is March 4; in many other locales the same keystrokes mean April 3, and Sheets will happily store the wrong one as a perfectly valid date. Addition still works - it just works on a start date a month away from the one you meant. When a result looks roughly a month off, check the locale under File, Settings before you blame the formula, and type dates in an unambiguous order while you work: year-month-day, or the month written as a word.
The Excel functions are here too
Anyone arriving from Excel will find the whole toolkit waiting. EDATE works in Sheets with the same syntax and the same month-end clamping, so =EDATE(A1,3) adds three calendar months in either program. WORKDAY and NETWORKDAYS also exist with the same arguments - start date, number of business days or end date, and an optional holiday range - so a working-days formula can move between the two programs unchanged. Even the serial numbers underneath match: Sheets counts days from the same epoch as Excel, which is why a date copied between them keeps its value. The differences that matter are the ones covered above - TODAY() recalculating, and the locale deciding what a typed date means - not the formulas themselves.
Frequently asked questions
Are the date formulas in Google Sheets the same as in Excel?
For day arithmetic, yes. =A1+45, =A1-45, EDATE, WORKDAY, NETWORKDAYS and TODAY all exist in Google Sheets with the same syntax and the same answers. Files can usually move between the two without the date formulas changing.
Why did Google Sheets change the date I typed?
Sheets interprets typed dates using the spreadsheet's locale setting. In a US-locale sheet, 02/03/2026 is February 3; in a UK-locale sheet it is March 2. To remove all doubt, build dates with =DATE(2026,2,3), which takes year, month and day separately and means the same thing in every locale.
How do I add months to a date in Google Sheets?
Use EDATE, exactly as in Excel: =EDATE(A1,1) adds one month and clamps to the last day of the month when the target month is shorter. Plain addition like =A1+30 adds 30 days, which is a different and usually wrong answer for a monthly schedule.
Why does my result show a long number instead of a date?
The cell is formatted as a number, so Sheets shows the stored serial value. Dates are stored as day counts - November 22, 2026 is 46348, the same serial Excel uses. Apply a date format from the Format menu and the number becomes a date.
How do I count the days between two dates in Google Sheets?
Subtract the earlier date from the later one: =B1-A1 gives the number of days between them. DATEDIF does the same job with units: =DATEDIF(A1,B1,"D") returns days, and its "M" and "Y" units return complete months and years.
