TodayFree forever - no sign-up, no paid plans

Adding years to a date - leap year edge cases

By Daniel Mercer · Updated November 5, 2026

Open the Date Calculator

Adding years to a date is the easiest count on the calendar - the same month, the same day, a bigger year number. It works for every start date except one. February 29 exists only in leap years, and every anniversary, contract and birthday anchored to it needs a rule for the three years out of four when it vanishes. This page sets out that rule and the other edge cases that cluster around leap years.

The clamp rule, applied to years

Year arithmetic uses the same clamp as month arithmetic: keep the month and day if they exist in the target year, and if they do not, land on the closest real day - February 28. Applied to the leap-day start date:

Start dateAddResultNote
February 29, 20241 yearFebruary 28, 2025Clamped - no Feb 29 in 2025
February 29, 20242 yearsFebruary 28, 2026Clamped again
February 29, 20244 yearsFebruary 29, 2028The date exists again
February 29, 20245 yearsFebruary 28, 2029Clamped - 2029 is not a leap year
February 28, 20271 yearFebruary 28, 2028No promotion to the 29th

The last row carries the rule's quiet half: clamping only ever moves a date down to a real day, never up. A schedule anchored on February 28 stays on February 28 through leap years; it does not drift onto the 29th when that day appears. Our date calculator follows this rule when you add years, and so does Excel's EDATE function - which is more than can be said for every method, as the spreadsheet trap below shows.

Adding years to a date and leap year edge cases - a birthday cake with many candles

One year is not always 365 days

The second edge case catches people who convert years to days. A one-year span is 365 days when it contains no February 29, and 366 when it does. March 10, 2026 plus one year is March 10, 2027, a span of 365 days. March 10, 2027 plus one year is March 10, 2028, a span of 366 days, because February 29, 2028 falls inside it. The calendar answer - same date, next year - never changes; only the day count underneath it breathes. Any system that prices a year at a flat 365 days will drift against anniversaries by a day per leap cycle, which is why contracts, warranties and ages are defined in calendar years and only converted to days when the document explicitly says so. The days between calculator on the homepage shows both readings of any span at once: the day total and the years-months-days breakdown.

Leap-day birthdays and legal ages

Roughly one person in 1,461 is born on February 29 (the honest odds come straight from the calendar: one leap day in each four-year cycle of 1,461 days). For them, "adding years" is a lived question. In common years most celebrate on February 28 or March 1 by family custom. Legal systems are less sentimental and less consistent: some treat March 1 as the date a leap-day baby reaches a new age in common years, others February 28, and the answer can differ between a driving licence, a contract and a pension rule inside the same country. A person born on February 29, 2024 turns 18 in 2042 - a year with no February 29 - so their exact legal birthday in that year is February 28 or March 1 depending on the rule being applied. When an age threshold matters, the document or the local law names the convention; the calendar alone cannot.

The spreadsheet trap - clamp versus rollover

Excel offers two natural ways to add a year, and they disagree on exactly this edge case. =EDATE(A1,12) clamps: from February 29, 2024 it returns February 28, 2025. Building the date by parts - =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)) - rolls over: asked for February 29, 2025, which does not exist, the DATE function carries the extra day forward and returns March 1, 2025. Two reasonable formulas, answers a day apart, and both "correct" by their own logic. For anniversary work, use EDATE and the clamp; save DATE-part construction for building dates from genuine components. It is the same clamp-versus-rollover split described in our guide to the month-end problem, wearing a leap-year costume.

The century rule - the edge case almost nobody meets

One more clamp hides a hundred years out. The leap rule skips century years not divisible by 400, so 2100 will have no February 29 even though it divides by 4. A 100-year span makes that real: February 29, 2000 plus 100 years cannot land on February 29, 2100, because that date will not exist - it clamps to February 28, 2100. Someone born on February 29, 2000 therefore reaches their hundredth birthday, by the calendar rule, on February 28, 2100. Almost no living person's paperwork spans a skipped century leap day, which is exactly why the rule survives as a trivia question. But long-dated instruments - 99-year leases, century bonds, perpetual licences with dated reviews - are written against it, and the clamp in this section is the rule their dates will follow when the time comes.

Frequently asked questions

What is one year after February 29?

February 28 of the following year, under the standard clamp rule: February 29, 2024 plus one year is February 28, 2025, because 2025 has no February 29. Four years later the date exists again - February 29, 2028 - and the anniversary returns to the 29th.

When does someone born on February 29 legally get older?

It varies by jurisdiction and by purpose. Some legal systems treat March 1 as the anniversary in common years, others February 28. For everyday life most leap-day babies celebrate on one of those two days - but for licences, contracts and age-restricted rights, the local rule in the document decides.

Is adding one year the same as adding 365 days?

Only when the span contains no February 29. March 10, 2026 plus one year is March 10, 2027 - 365 days. March 10, 2027 plus one year is March 10, 2028 - 366 days, because the span includes February 29, 2028. The calendar answer is stable; the day count is not.

How do I add years to a date in Excel?

Use =EDATE(A1,12) for one year, which clamps February 29 to February 28 in common years. Avoid building the date with =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)) for leap-day starts: Excel rolls the impossible February 29 forward to March 1 instead of clamping it back.

How often do leap years happen?

Every four years, with a century exception: years divisible by 4 are leap years, except century years, which are leap years only if divisible by 400. So 2000 was a leap year, 1900 was not, and 2100 will not be. The next leap years are 2028, 2032 and 2036.

Related guides

Adding months to a date - the month-end problem

The clamp rule at the monthly scale, and its drift.

How to calculate expiry dates and warranty end dates

Anniversary-rule cover and the 1,096-day warranty.

What date is 1,000 days from today?

A long day count with a leap day inside it.

How to calculate the date 6 months from now

Calendar spans that are not fixed day counts.

Daniel Mercer

Daniel Mercer builds and maintains the calculators on this site. He spent ten years in payroll and operations roles counting business days, notice periods and deadlines by hand, and writes these guides the way he would explain the count to a colleague - the rule first, a worked example second, and the common mistake called out before it happens.