Add 1 Year 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. For “add 1 year to a date in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. 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. That is what makes a layout choice that keeps the sheet readable and sortable useful in real work: repeatable, auditable, and not dependent on memory or luck.

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

If you are in Google Sheets rather than Excel, the good news is that the formula shown here is identical and the workflow barely changes — menus sit across the top instead of in a ribbon, and a few function names differ slightly, but anything you build here moves across with little or no rework. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. If you take one thing from this page on “add 1 year to a date in excel”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.

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