Adding Days to Dates in Excel: The Simple Formula Method

The fastest way to add days to a date in Excel

To add days to a date in Excel, type a formula that subtracts or adds a number to the date cell. The simplest version is =A1+5, which adds 5 days to whatever date sits in cell A1. Excel treats dates as numbers behind the scenes — January 1, 1900 is day 1, January 2 is day 2, and so on — so adding a whole number to a date cell just moves forward that many days.

If your date is in cell A1 and you want the result in cell B1, click B1, type =A1+5, and press Enter. The cell will show a date five days later. You can change the 5 to any number of days you need. If you want to subtract days instead, use a minus sign: =A1-10 subtracts 10 days.

This works in Excel on Windows, Mac, and in Google Sheets with identical syntax. The date format of the result depends on how that cell is already formatted — if B1 is set to show dates, it will display as a date; if it is set to show numbers, it will show as a number. Usually Excel guesses correctly and shows it as a date.

Key Takeaways

Add days to a date by typing =A1+5 in a new cell, where A1 contains your date and 5 is the number of days to add.
Subtract days using a minus sign: =A1-10 removes 10 days from the date in A1.
The result cell must be formatted as a date to display correctly; if it shows a large number instead, right-click and choose Format Cells, then select Date.
To add months or years instead of days, use the DATE and MONTH functions together: =DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)) adds three months.

When the result shows a number instead of a date

If you type =A1+5 and the cell shows something like 45127 instead of a date, the cell format is set to Number rather than Date. This is the actual value Excel stores — it is not wrong, just not readable. To fix it, right-click the cell with the number, select Format Cells, click the Number tab, and choose Date from the Category list on the left.

Pick a date format from the list — most people choose the one that looks like "3/15/2024" or "2024-03-15" depending on your region. Click OK and the cell will when ready show the date instead of the number. The formula has not changed; only the display has.

If you are working in Google Sheets, right-click the cell, select Format cells, click Number in the menu on the left, and choose Date from the dropdown.

Adding months or years instead of days

To add a whole number of months to a date, the straightforward addition formula does not work — you need the DATE and MONTH functions together. The formula is =DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)), which adds 3 months to the date in A1 while keeping the day of the month the same.

Break down what this does: YEAR(A1) pulls the year from your date, MONTH(A1)+3 pulls the month and adds 3 to it, and DAY(A1) pulls the day. DATE then reassembles them into a new date. If your original date is March 15, 2024, this formula produces June 15, 2024.

To add years instead, use =DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)), which adds 2 years. Change the 2 to whatever number of years you need. If you want to add both months and years, combine them: =DATE(YEAR(A1)+1,MONTH(A1)+6,DAY(A1)) adds 1 year and 6 months.

Copying the formula down to multiple rows

If you have a list of dates in column A and want to add days to all of them at once, type the formula =A1+5 in cell B1, then copy it down to the other rows. Click B1 first, then look for the small square at the bottom right corner of the cell — this is the fill handle. Click and drag it down to B10 (or however many rows you have), and Excel will automatically adjust the formula for each row: B2 becomes =A2+5, B3 becomes =A3+5, and so on.

If dragging feels awkward, there is a faster way: click B1, copy it (Ctrl+C on Windows or Cmd+C on Mac), then select the range B2:B10 and paste (Ctrl+V or Cmd+V). Excel will adjust the formula for each row automatically.

The same method works for the DATE formula with months or years. Type it once in B1, then copy it down to all the rows that need it.

Combining dates and times in the formula

If your cells contain both a date and a time — for example, "3/15/2024 2:30 PM" — adding a whole number still works, but it adds full 24-hour days. Adding 1 moves forward exactly one day at the same time. If you want to add hours or minutes instead, you need to use a decimal: adding 0.5 adds 12 hours (half a day), and adding 0.25 adds 6 hours (a quarter day).

For example, =A1+0.5 adds 12 hours to a date-time value in A1. To add a specific number of hours, divide by 24: =A1+(8/24) adds 8 hours. To add minutes, divide by 1440 (the number of minutes in a day): =A1+(30/1440) adds 30 minutes.

What happens when you add days across month or year boundaries

Excel handles month and year boundaries automatically. If your date is March 28 and you add 5 days, the result is April 2 — Excel does not require you to think about when months end. The same applies to year boundaries: if your date is December 28 and you add 5 days, the result is January 2 of the next year.

This is why the straightforward addition formula works so well for adding days. You do not have to write logic to check whether you are crossing a month boundary or a leap year. Excel has already done that work.

Using cell references instead of typing numbers

Instead of typing a fixed number like 5 into your formula, you can reference another cell that contains the number of days to add. If cell C1 contains the number 5, you can type =A1+C1 to add that many days to the date in A1. This is useful when the number of days changes or when you want to reuse the same formula with different values.

You can also build a formula that adds different numbers of days based on a condition. For example, =A1+IF(B1="rush",1,5) adds 1 day if cell B1 says "rush" and 5 days otherwise. This keeps your spreadsheet flexible when the rule for how many days to add depends on something else in the data.

Frequently Asked Questions

Can I add a decimal number of days, like 2.5 days?

Yes. =A1+2.5 adds 2 and a half days — 2 full days plus 12 hours. Excel treats the decimal part as a fraction of a 24-hour day, so 0.5 is noon the next day, 0.25 is 6 AM, and so on. This is most useful when your cells show both date and time.

What if I want to add business days only, skipping weekends?

Use the WORKDAY function instead: =WORKDAY(A1,5) adds 5 business days to the date in A1, automatically skipping Saturdays and Sundays. If you need to exclude holidays too, use =WORKDAY(A1,5,holidays), where "holidays" is a range of cells containing holiday dates.

Why does my formula show an error like #VALUE!?

This usually means the cell you are adding to does not actually contain a date — it contains text that looks like a date. Try clicking the cell and checking the formula bar at the top to see exactly what is stored there. If it is text, you may need to convert it to a real date first using the DATEVALUE function: =DATEVALUE(A1)+5.

Can I add days to today's date without typing a specific date?

Yes, use the TODAY function: =TODAY()+5 adds 5 days to today. Every time you open the spreadsheet, TODAY() updates to the current date, so the formula always adds 5 days from now. If you want today's date plus time, use NOW() instead: =NOW()+5.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.