TodayFree forever - no sign-up, no paid plans

Adding months to a date - the month-end problem explained

By Daniel Mercer · Updated November 2, 2026

Open the Date Calculator

Adding months to a date looks like the easiest arithmetic on the calendar - keep the day number, move the month. It works beautifully until the day number is 29, 30 or 31 and the month you land in does not have that day. This page explains the clamp rule that business software uses, the drift it causes in recurring schedules, and how to predict the answer for any start date.

The clamp rule

When you add months to a date, the result keeps the same day of the month if it can. If the target month is too short to hold that day, the result clamps - it lands on the last day of the target month instead. That is the whole rule, and every example on this page is just the rule applied:

Start dateAddResultWhat happened
January 31, 20261 monthFebruary 28, 2026Clamped - February 2026 has 28 days
January 31, 20241 monthFebruary 29, 2024Clamped - leap year February has 29
March 31, 20261 monthApril 30, 2026Clamped - April has 30 days
October 31, 20261 monthNovember 30, 2026Clamped - November has 30 days
August 31, 20266 monthsFebruary 28, 2027Clamped - February 2027 has 28 days
December 31, 20261 monthJanuary 31, 2027No clamp needed - January has a 31st

Our date calculator uses this rule when you add months, and so does Excel's EDATE function and most billing, payroll and contract software. It is worth knowing that the alternative exists: some programming tools roll the overflow forward, so January 31 plus one month becomes March 3 (the 31st that February could not hold, plus the missing days). Rollover is defensible in code and baffling in business, which is why clamp won. If two tools ever give you different month-end answers, you have almost certainly found one of each.

Adding months to a date and the month-end problem - notes and a laptop on a desk

Clamp drift - the second, quieter problem

Clamping has a side effect that catches recurring schedules. Add one month to January 31 and you get February 28. Add another month to that result and you get March 28, not March 31 - the anchor day was lost at the first clamp and the schedule never recovers it. Month by month, a "31st of the month" schedule quietly becomes a "28th of the month" schedule after its first February.

Compare that with a single two-month jump: January 31 plus 2 months in one step is March 31, because the clamp only applies to the final landing month, and March has a 31st. Same start, same total months, two different answers - February 28 then March 28 by steps, or March 31 in one jump. Well-built recurring systems decide in advance which behaviour they promise: many billing platforms store the original anchor day and restore it when the month allows ("end of month stays end of month"), while simple monthly formulas drift. If you run a schedule anchored on the 29th, 30th or 31st, test what your software does across a February before you trust it.

Three start dates, one landing day

February produces another curiosity worth knowing. In 2026, January 29 plus one month, January 30 plus one month and January 31 plus one month all land on February 28 - three different start dates converging on a single result. Nothing is broken; the clamp compresses them. It does mean the operation cannot be run backward uniquely: one month before February 28, 2026 might have been January 28, 29, 30 or 31. Systems that schedule monthly events avoid the whole tangle by anchoring on days 1 to 28, which exist in every month - one reason so many contracts and subscriptions quietly use the 28th or earlier.

Where this actually bites

Rent and subscriptions. A tenancy or subscription starting on January 31 renews on February 28, and the March renewal depends on the drift rule - the 28th or back to the 31st. The contract wording decides; the calendar does not.

Loan and card payments. Monthly payments scheduled for the 31st are routinely collected on the last day of shorter months instead. Lenders document this as a clamp, and it is one reason payment dates appear to wander by a day or two across a year.

Probation and notice in months. "Three months from August 31" ends on November 30, not a nonexistent November 31 - and our guide to the date 6 months from now works the longer version of the same rule. For counting the full months between two dates you already hold, the days between calculator on the homepage gives the years, months and days breakdown directly.

Subtracting months clamps too

The rule runs in both directions. One month before March 31, 2026 is February 28, 2026, because February cannot hold a 31st; one month before May 31 is April 30. Backward clamping has the same drift question as forward clamping: a schedule stepping back from March 31 reaches February 28, and the next step back lands on January 28 rather than January 31. If you are unwinding a monthly schedule, decide whether the anchor day should be restored when a longer month returns, and apply that decision consistently in both directions.

Frequently asked questions

What is one month after January 31?

February 28 in a normal year, or February 29 in a leap year. February has no 31st day, so the result clamps to the last day of February. January 31, 2026 plus one month is February 28, 2026; January 31, 2024 plus one month is February 29, 2024.

Why did two monthly steps from January 31 give March 28 instead of March 31?

That is clamp drift. The first step lands on February 28, and the second step starts from the 28th, so it lands on March 28. A single two-month jump from January 31 gives March 31, because March has a 31st day. Recurring schedules need a rule for which behaviour they use.

What is 6 months after August 31?

February 28, 2027. Six months after August is February, and February 2027 has only 28 days, so the 31st clamps to the 28th. The same clamp appears whenever a 31st lands in a shorter month.

Do all calculators and spreadsheets handle month end the same way?

No. Most business software, including Excel's EDATE function, clamps to the last day of the target month. Some programming tools roll the extra days forward instead, turning January 31 plus one month into March 3. If two tools disagree at month end, this is almost certainly why.

How do I add months to a date in Excel?

Use EDATE: =EDATE(A1,1) adds one month to the date in A1, clamping at month end where needed. Use a negative number to go backward. Plain addition like =A1+30 adds days, not months, and gives a different answer.

Related guides

Why adding 30 days is not the same as adding one month

The day-count versus month-count trap, with the January 31 example.

How to calculate the date 6 months from now

The same-date rule, the clamp, and why 6 months is not 182 days.

Adding years to a date - leap year edge cases

What happens to February 29 birthdays and anniversaries.

How to add days in Excel - simple formulas and EDATE

EDATE in practice, plus the plain-addition method for days.

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.