Excel Formula for Adding Calendar Days: Simple Steps

Formulas & functions · Updated November 22, 2026

The simplest Excel formula for adding calendar days to a date is =A2+7 (to add 7 days) or =A2+30 (to add 30 days), where A2 holds the starting date. Because Excel stores dates as serial numbers, plain addition works for calendar days, skipping nothing and including weekends and holidays automatically.

Why Plain Addition Works

Excel treats every date as an integer: January 1, 1900 is serial number 1, January 2 is 2, and so on. Today (for example, March 14, 2025) is serial number 45730. When you write =A2+7, Excel adds 7 to that serial number, which lands exactly 7 calendar days later. This is the same logic behind the EDATE function for months, but for days you do not need a special function at all.

A common misconception is that you need DATE or DAYS functions. You do not. The DAYS function calculates the difference between two dates, not the addition. The DATE function is only useful when building a date from separate year, month, and day cells. For adding a fixed number of days to an existing date, simple arithmetic is the fastest and most reliable method.

How to Write the Formula (Step by Step)

Assume your starting date is in cell A2 and you want the date 10 days later in cell B2.

  1. Click cell B2.
  2. Type =A2+10 and press Enter.
  3. If B2 shows a number like 45740 instead of a date, select B2, go to the Home tab, and choose Short Date or Long Date from the Number Format dropdown.

To add a variable number of days stored in another cell, say C2 contains 10, use =A2+C2. This works because Excel reads the numeric value in C2 as days.

For a full column of dates, enter the formula in the first result cell and double-click the fill handle (the small square at the bottom-right of the cell) to copy it down. On a Mac, the fill handle works the same way.

Adding Days While Keeping the Time of Day

If your date cell also contains a time (for example, 3/14/2025 8:30 AM), adding an integer still works: =A2+7 returns 3/21/2025 8:30 AM. The time portion is a decimal fraction of the day, and integer addition leaves it untouched. If you only want the date without the time, wrap the result in =INT(A2+7) and format as a date.

Handling Weekends and Holidays (Workdays vs Calendar Days)

Plain addition adds every day, including Saturdays, Sundays, and holidays. That is exactly what “calendar days” means. If you need to skip weekends, use =WORKDAY(A2,10) to add 10 working days (Monday through Friday). To also skip holidays, list them in a range, say H2:H10, and use =WORKDAY(A2,10,H2:H10). For a custom weekend (e.g., Sunday only), use =WORKDAY.INTL(A2,10,11) where 11 means Sunday is the only weekend day. These functions return a date serial number, so format the result as a date.

Note that WORKDAY and WORKDAY.INTL are available in all modern Excel versions, including Excel for the web. On Mac, the function names and syntax are identical.

Common Problems and Fixes

Problem 1: The result shows a number, not a date. This happens when the cell format is General. Select the cell, press Ctrl+1 (Windows) or Cmd+1 (Mac), choose Date, and pick a format.

Problem 2: Adding days gives an error like #VALUE!. This usually means the original cell is text, not a real date. Check if A2 is left-aligned (text) instead of right-aligned (date). Convert text dates using =DATEVALUE(A2) first, or use Data > Text to Columns > Delimited > Next > Next > Date (MDY) to convert the column.

Problem 3: Negative days. You can subtract days with =A2-5. Excel handles negative results correctly, going back in time. If you go before January 1, 1900, Excel displays a series of # signs because dates before 1900 are not supported.

Problem 4: Adding 30 days to January 31. Excel does not roll over to February 30; it correctly returns March 2 (in a non-leap year). The serial number arithmetic handles month lengths automatically, so you never need to worry about month boundaries.

Alternatives: EDATE, DATE, and SEQUENCE

For adding months, use =EDATE(A2,1) to add one month. This is different from adding 30 days because months have varying lengths. For constructing a date from components, use =DATE(2025,3,14)+10. For generating a list of dates in a column, use =SEQUENCE(10,1,A2,1) to create 10 consecutive days starting from A2. This requires Excel 365 or Excel 2021. On older versions, you would drag the fill handle instead.

If you need to add days to a date stored as text (e.g., “2025-03-14”), first convert with =DATEVALUE(A2) and then add days. Alternatively, use =DATE(YEAR(A2),MONTH(A2),DAY(A2)+7), but this is unnecessarily complex and can fail if the day exceeds the month length (e.g., day 31 + 7 = 38, which Excel rolls to the next month correctly in most cases, but it is less transparent).

Frequently Asked Questions

Does adding days include weekends? Yes, plain addition includes all seven days of the week. If you want only business days, use =WORKDAY(A2,10).

What if my date is in text format? Use =DATEVALUE(A2)+7 to convert the text to a real date first, then add days. Format the result as a date.

How do I add days to today’s date? Use =TODAY()+30 to get the date 30 days from now. TODAY() updates every time the workbook recalculates.

Can I add days to a date and keep the time? Yes, integer addition preserves the time portion. For example, =A2+1 adds exactly 24 hours, so if A2 is 3/14/2025 3:00 PM, the result is 3/15/2025 3:00 PM.

Why does my formula return a number like 45234? That is the serial number. Change the cell format to Date via Home > Number Format > Short Date. This is the most common beginner mistake.

Is there a difference between adding days in Excel and Google Sheets? No, both use the same serial number system and the same =A2+7 syntax. The only difference is that Google Sheets defaults to a different date system (1900 or 1904) depending on the spreadsheet settings, but for normal dates the results are identical.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.