The add-days-to-date formula is: result date = start date + N calendar days. In Excel or Google Sheets, write it as =A2+B2 when A2 contains the start date and B2 contains the number of days to add. To subtract, use =A2-B2, or keep =A2+B2 and enter a negative day amount.

This is calendar-day arithmetic: Saturdays, Sundays, and leap days are counted. It answers what date a period lands on, not how many working days remain. That distinction matters for deadlines that must fall on a business day.

add days to date formula
Add Days to Date Formula: Simple Spreadsheet Guide

The add days to date formula

The formula works from a starting point and a signed interval. The start date supplies the calendar position, while N tells the calculator how far to move. A positive N moves forward; a negative N moves backward. The result is another calendar date, not a duration or a business-day count.

  • Start date: The date from which the calculation begins.
  • Offset: The amount N to add or subtract. For straightforward date arithmetic, use a whole number of days.
  • Unit: Days are the base unit; weeks use exact seven-day multiples, while months and years follow calendar rules.

Days and weeks are straightforward because each day has the same length. Months and years are not. Their target position depends on the starting month, the number of days in the target month, and leap-year status. A calendar-aware calculation therefore cannot be replaced with one fixed day count for every month.

Excel and Google Sheets formulas

For one calculation, put the starting date in cell A2 and the day amount in cell B2. For a column of dates, the same pattern can be filled down, with each row referencing its own date and offset.

  1. Enter or select the start date in A2 and make sure the spreadsheet recognizes it as a date.
  2. Enter a whole-number day amount in B2. Use a positive value to add or a negative value to subtract with the addition formula.
  3. In C2, enter =A2+B2. Copy the formula down when each row has matching cells in columns A and B.
  4. If the result appears as a number, format cell C as a date rather than leaving it in a general numeric format.
Spreadsheet task Formula Meaning
Add days =A2+B2 A2 is the start date and B2 is a positive day amount.
Subtract days =A2-B2 A2 is the start date and B2 is a positive day amount.
Use one signed field =A2+B2 B2 can contain either a positive or negative day amount.

Relative references make the formula convenient for a table. When =A2+B2 is copied into the next row, it changes to the corresponding cells, so each result follows its own inputs. If you need one fixed date while changing only the amount, use an anchored reference for that date cell.

Spreadsheet day arithmetic is appropriate when every adjustment is expressed in days. It does not automatically apply the calendar-aware rules needed for a month or year offset, especially at the end of a month. For those units, use a date calculator rather than treating every month as the same number of days. If an Excel result appears as a serial number, follow the guide on how to change Excel dates to dd/mm/yyyy format to correct its display.

Add days with the live date calculator

  1. Open the Date Add Subtract Calculator and choose your start date in the date field. It defaults to today, but you can select another date.
  2. Select Add or Subtract, type the amount, and choose Days, Weeks, Months, or Years.
  3. Read the result date and its weekday shown instantly below. There is no button to press; the answer updates as you change the amount or unit.

Alongside the full date and weekday, the calculator displays a compact summary with an ISO-style result that can be copied into a spreadsheet, calendar entry, or ticket. Changing the amount or unit recalculates the answer immediately, making it easy to compare short and long planning horizons.

Everything runs in your browser. The date you enter stays on your device, nothing is uploaded or stored, and no signup is required. There is also no limit on how many calculations you can run.

Month-end, year, and leap-day rules

Month and year additions preserve the intended calendar position when possible. If the target month has no matching day, the result is clamped to that month’s last valid day rather than rolling into the following month.

Worked example: Starting on January 31 and adding one month lands on February 28 in a common year, or February 29 in a leap year. It does not roll into March because the result stays inside the requested target month.

Year additions use the same clamping principle whenever the original month-and-day combination is absent from the target year. Leap years follow the full Gregorian rule: they are divisible by 4, except for century years unless those years are also divisible by 400. The calculator applies those February lengths and day counts automatically.

Weeks are exact seven-day multiples, so week arithmetic rolls across month and year boundaries in the same way as day arithmetic. Subtractions can also move far enough into past centuries while keeping the calendar consistent.

Choose the unit that matches the task

Select the unit that reflects the meaning of the deadline rather than the number you expect to see.

Use case Unit Rule Important check
Day-level deadline Days Advances one calendar day per unit. Weekends are included.
Fixed weekly interval Weeks Uses exact seven-day multiples. Boundary behavior matches days.
Monthly renewal Months Keeps the calendar-month position. The target day may require clamping.
Annual anniversary Years Keeps the month and day position. A missing target date is clamped.

Days suit shipping, billing, and trial periods when weekends count. Weeks are useful for fixed seven-day schedules. Months are better for renewals or billing cycles that follow the calendar, while years suit contract or anniversary dates. When different units could produce different outcomes, calculate with the intended unit instead of converting it into an assumed fixed day count.

Checks before you copy a result

Before using a calculated date, review the inputs and interpretation together.

  • Start date: Confirm the full year, month, and day shown in the date field.
  • Direction: Check that Add or Subtract matches the intended direction and that any negative offset is deliberate.
  • Amount and unit: Confirm whether the target is a fixed day count, a calendar month, or an anniversary.
  • Weekday: Read the weekday displayed with the result and check whether the target falls on a weekend.
  • Output: Copy the full result or compact ISO summary, then compare it with the original inputs.

The main limitation is that the calculator counts calendar days; it does not skip weekends. For a deadline that must exclude weekends, use the Business Days Calculator instead. If your task is to find the interval between two known dates, rather than add an offset to one date, use a days-between calculator. For age or a birth-date anniversary, use an age calculator.

The output is a calculated date and its weekday, not a recommendation about which deadline to choose. A quick check of the start date, operation, amount, and unit is still the best way to prevent an accidental sign error or an unintended calendar assumption.

Choose between a formula and the calculator

The spreadsheet formula and the live calculator solve related but different tasks. Choose the workflow that matches where the dates already live and what information you need at the end.

  • Use =A2+B2 for repeated rows in an existing sheet where each row contains a date and a day offset.
  • Use the live calculator for a one-off date, direct weekday output, and unit choices including weeks, months, and years.
  • Use the business-days tool when weekends must be excluded from the calculation.
  • Use a difference or age tool when the task begins with two dates or a birth date rather than one date plus an offset.

Whichever method you choose, record the start date, direction, amount, and unit. Those four details make the result easier to verify and prevent most date errors: a wrong month, a reversed sign, or an accidental weekend assumption.

Related reading: Date Difference Calculator: Accurate Results and Checks.