TodayFree forever - no sign-up, no paid plans

Month-end dates - why January 31 plus one month is tricky

By Daniel Mercer · Updated November 19, 2026

Open the Months Between Dates Calculator

Ask a simple question - what is one month after January 31? - and you have found the single most argued-about corner of date arithmetic. There is no February 31 for the answer to land on, so every calculator, spreadsheet, payroll system and contract has to choose what to do instead, and they do not all choose the same thing. This guide explains the standard answer, why it is the standard, and the one situation - adding months in a chain - where even good systems quietly split into two camps.

The clamp: February 28

The standard rule is called clamping. When the target month lacks the day you need, the date clamps to the last day that month has. January 31 plus one month is therefore February 28 in 2026 (and February 29 in a leap year like 2028). October 31 plus one month is November 30. March 31 plus one month is April 30. The rule is used by Excel's EDATE function, by Google Sheets, by the date libraries inside virtually every programming language, and by our months between dates calculator, where it also runs in reverse: a span from January 31 to February 28 counts as exactly 1 full month, even though it is only 28 days long - the shortest full month there is.

The alternative to clamping would be spilling: February 31 becomes March 3, because the nonexistent days roll forward. Almost nothing uses spill, for an obvious reason - it would mean that adding one month to January 31 lands you in March, and adding a month to a date near the end of a 31-day month could add up to 34 days. Clamping keeps "plus one month" inside the month it names. When you read that a system "handles month-end correctly", clamping is what it means.

Month-end dates at the turn of the year, when January 31 plus one month clamps to February

Where the two camps split: adding months in a chain

Clamping settles single jumps. The argument starts with the second jump. There are two ways to add two months to January 31:

From the original date. Work out January 31 plus 2 months in one step: the target is March, March has a 31st, so the answer is March 31. This is what EDATE does - =EDATE(DATE(2026,1,31),2) returns March 31, 2026 - and it is what most date libraries do when you add a multi-month period to a stored start date. The clamp only bites on the final landing.

One month at a time. Add one month, get February 28, then add one month to that: the answer is March 28. The 31st is lost at the first clamp and never comes back. This chained behaviour is how many billing and renewal systems actually run, because each cycle is calculated from the last one - it is the reason a subscription taken out on the 31st renews on the 28th forever after, a drift our guide on subscription billing cycles examines in detail.

Neither camp is buggy; they are answering slightly different questions. But the three-day difference is real money on a rent payment, a salary date or a contract anniversary, so for anything that started on the 29th, 30th or 31st it is worth asking which method produced a date before you rely on it. Our guide to adding months to a date shows both methods side by side with more examples.

The full clamp table

Clamping only ever happens in the month after a longer month, and February is the extreme case. The complete pattern for anniversaries and one-month jumps:

Start datePlus 1 monthNote
January 31, 2026February 28, 2026Clamped - February has 28 days in 2026
January 31, 2028February 29, 2028Clamped to the leap day
January 30, 2026February 28, 2026Clamped - no February 30 either
January 29, 2026February 28, 2026Clamped in a normal year only
March 31, 2026April 30, 2026Clamped - April has 30 days
August 31, 2026September 30, 2026Clamped - September has 30 days
October 31, 2026November 30, 2026Clamped - November has 30 days
May 31, 2026June 30, 2026Clamped - June has 30 days

Every other start day - the 1st through the 28th - has an anniversary in every month of the year and never clamps at all. This is why the 28th is the safest day of the month to anchor a recurring payment to, a trick worth knowing if you are the one choosing the dates. It is also why month-end starts produce the strangest month counts, like the 28-day full month described in our guide on full months vs partial months.

What to do about it in practice

Three habits cover nearly every real situation. First, if you are signing something that starts on the 29th, 30th or 31st - a lease, a contract, a loan - ask how anniversaries in short months are handled, and get the answer in writing; our guide on counting months on a lease shows the clauses to look for. Second, when you check a month count, check it with a tool that states its convention: the months calculator here clamps, like Excel and Sheets, and says so. Third, never chain month additions by hand for a date that matters - count from the original anchor date each time, the way EDATE does, and the 31st will still be there when March comes round. If you only need the raw day count underneath it all, the days between calculator on the homepage is immune to the whole question, because days never clamp.

Frequently asked questions

Why does January 31 plus one month give February 28?

Because February 2026 has only 28 days, so the target date, February 31, does not exist. Rather than spilling into March, the standard rule clamps the result to the last day that does exist: February 28. The alternative - rolling over to March 3 - would mean adding one month sometimes adds nearly two, which no billing or payroll system accepts.

Is January 31 to February 28 really a whole month?

Yes, under the clamping convention used by Excel, Google Sheets and this site. It is 28 days long, which makes it the shortest possible full month, but the anniversary falls on February 28 and the month completes there. A minority of counters refuse to clamp and report 0 months and 28 days instead, which is why month-end spans are the ones two tools most often disagree on.

What does Excel's EDATE give for January 31 plus 2 months?

March 31. EDATE always calculates from the original date you gave it, applying the clamp only to the final result, so the two-month jump from January 31 lands on the real March 31. This is different from adding one month twice: January 31 clamped to February 28, plus one more month, gives March 28 in systems that chain the calculation.

Why does my subscription renew on the 28th when I signed up on the 31st?

Because the billing system adds each month to the previous renewal date instead of to your original sign-up date. The first renewal clamped from January 31 to February 28, and every later month was added to the 28th, so the date drifted and never returned to the 31st. Well-built systems store the original anchor day and return to it; drifting systems are the common cause of this complaint.

How are months counted from a start date of January 29 or 30?

The same clamping applies, but only in February. January 30 plus one month is February 28 in 2026 (February 29 in a leap year), and January 29 plus one month is February 28 in a normal year and February 29 in a leap year. Every other month has a 29th and a 30th, so anniversaries land normally for the rest of the year.

Related guides

How to add months to a date

EDATE, chained addition, and which one your system uses.

How to count months on a lease or contract

Month-end start dates in real tenancy agreements.

How to count months for a subscription or billing cycle

Anchor days and the renewal drift, in full.

How to calculate months between two dates

The anniversary method that clamping completes.

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.