How to Add Days to a Date in Excel

What this does

Dates in Excel are serial numbers, so adding days is ordinary arithmetic: =A2+30. Months and years are not, because months have different lengths — that is what EDATE is for. =EDATE(start_date, months) moves the date by whole months and clamps to the end of the month when the day does not exist, so 31 January plus one month is 28 February, not 3 March. EOMONTH does the same jump but always lands on the last day of the target month. Negative arguments subtract. The result comes back as a serial number, so format the cell as a date afterwards. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “add days to a date in excel”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above before you touch the real workbook. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. The point is a layout choice that keeps the sheet readable and sortable, but the practical win is that someone else can open the file and understand what happened without asking you.

A worked example

A2 holds 2026-01-31. =EDATE(A2,1) returns 2026-02-28 — EDATE clamps rather than overflowing. =EDATE(A2,-2) returns 2025-11-30. Two years on: =EDATE(A2,24) gives 2028-01-31. For the last day of the month three months out, =EOMONTH(A2,3) gives 2026-04-30. Adding days needs no function: =A2+45 is 2026-03-17. Adding working days instead: =WORKDAY(A2,45) skips weekends, and a third argument takes a range of holidays. Renewal dates, payment terms, contract ends and review cycles are all "start date plus N months", and the difference between EDATE and adding 30 is a rolling error that shows up as an off-by-a-few-days invoice. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.

In Google Sheets

Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top, the tool proves it, and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. The short version of “add days to a date in excel”: the answer is at the top of this page, the tool proves it on your own numbers, and the sections above explain why it holds so the next variation does not stump you. Excel rewards people who reference cells instead of typing values and who keep inputs separate from formulas, because that is what makes a result you can audit months later. Build it once, deliberately, with the live tool as a check, and you convert a one-off lookup into a reusable skill — which is the whole point of learning the why and not just the what.

Common mistakes

• Adding 30 or 365 as an approximation of a month or a year, which drifts and breaks on leap years.
• Expecting 31 January + 1 month to be 3 March; EDATE clamps to 28 or 29 February by design.
• Leaving the result as General format and reporting a five-digit serial number.
• Feeding EDATE a date held as text, which returns #VALUE! — convert it with DATEVALUE or Text to Columns first.
• Using EDATE when the requirement is "the last day of the month", which is EOMONTH's job.

Frequently asked questions