TodayFree forever - no sign-up, no paid plans

Common months-between mistakes - rounding and partial months

By Daniel Mercer · Updated November 21, 2026

Open the Months Between Dates Calculator

Month counts go wrong in a small number of predictable ways. After years of checking other people's figures, the same six errors account for nearly every dispute: a rounded-up partial month, a 30-day shortcut, a spreadsheet counting month names instead of anniversaries, and three quieter ones. This guide names each mistake, shows it happening on real dates, and gives the fix - so you can spot them in other people's numbers as fast as in your own.

Mistake 1: rounding the partial month up

The champion. A span from January 15 to April 14, 2026 is 2 full months and 30 days - one day short of three months. In conversation it becomes "about 3 months", in a plan it becomes "3 months", and in a deadline diary it becomes April 14 as the day a 3-month probation ends, when the probation actually ends on April 15. The error is never in the counting; it is in the retelling. Fix: keep the two-part answer in writing, always - the habit our guide on full months vs partial months is built around. Round in speech if you must, with the word "about" doing honest work.

Mistake 2: the 30-day month shortcut

Dividing the day count by 30 feels like arithmetic and behaves like a slow leak. A real month averages 30.436875 days, so every division by 30 overstates the span, and the error compounds: across 36 months it invents more than two weeks. The same shortcut in reverse - calling every month 30 days when adding - makes a "6-month" deadline land days early. Fix: if you truly need a decimal, divide by the average month, 30.436875, and label it an estimate, as our guide on the average month sets out. If dates are attached, do not divide at all - count anniversaries with the months between dates calculator.

Checking a spreadsheet for common months between mistakes at a laptop

Mistake 3: counting month names instead of anniversaries

"From January to December is 12 months" - it sounds right and it is the inclusive-counting error in its purest form. January 1 to December 31, 2026 touches 12 month names, but the elapsed count is 11 full months and 30 days: the twelfth month completes on January 1, 2027. Spreadsheets make this mistake mechanically when a formula subtracts MONTH values or counts boundaries crossed, and it is why a home-grown formula so often disagrees with DATEDIF's "M" unit by exactly one month. Fix: count anniversaries, not boundaries - the method in our guide on how to calculate months between two dates - and in a spreadsheet use DATEDIF, whose whole job is this distinction.

Mistake 4: trusting the average month for a dated job

Dividing 90 days by 30.436875 gives 2.96 months, and reporting "2.96 months" for the span January 15 to April 15, 2026 buries the fact that the true answer is exactly 3 months - while the same division on the 92-day span July 15 to October 15 reports 3.02 months for another exactly-3-month span. The average month cannot see anniversaries, so it cannot answer dated questions: deadlines, ages, due dates, notice periods. Fix: match the tool to the question. Estimates and statistics can use the average; anything with a date on it gets the calendar count, which the months calculator gives alongside the average figure so you can see both.

Mistake 5: chained addition and the vanishing 31st

Add one month to January 31 and you get February 28. Add another month to that result and you get March 28 - the 31st has silently vanished, and every later date in the chain is three days early. Systems that renew, bill or schedule by adding a month to the last result all drift this way. Fix: always add months from the original anchor date, never from the last computed date. Excel's EDATE does this correctly in one step - =EDATE(start, 2) from January 31 gives March 31 - and our guide on month-end dates shows the full picture.

Mistake 6: dropping the leftover days

The quietest error: reporting "7 months" for a span of 7 months and 20 days, because the tool or the formula only showed the months. Twenty days is two-thirds of a typical month - dropping it understates the span by more than most of the other mistakes on this page. It happens whenever someone uses DATEDIF's "M" unit without its "MD" partner, or reads only the headline figure from a counter. Fix: a month count is not finished until the leftover days are stated, even when the leftover is zero. "7 months and 20 days (February 10 to September 30, 2026)" is a complete fact; "7 months" is half of one. Cross-check with the days between calculator - that span is 232 days, and a 7-month answer attached to it should immediately prompt the question "and how many days over?"

The two checks that catch all six

Every mistake above is caught by the same pair of checks. First, add the answer back: start date plus full months plus leftover days must land exactly on the end date. Second, reconcile with the day count: the span in days must be plausible for the month answer - five months always holds 150 to 153 days, seven months 212 to 215 - so a month figure that cannot be reconciled with the day total is wrong somewhere. Run both checks on any figure someone hands you, and you will catch their rounding, their shortcut and their dropped days before the figure costs anyone anything.

Frequently asked questions

What is the most common months-between mistake?

Rounding a nearly complete month up to a whole one. A span of 2 months and 30 days becomes "3 months" in conversation, then in a diary, then in a deadline - and the probation, notice period or contract term ends a day early. The fix is to keep the two-part answer, full months plus leftover days, in anything written down.

Why do two calculators give me different month counts?

Usually because they use different conventions on one of three points: whether the anniversary clamps at month-end (January 31 to February 28 counting as a full month), whether both end dates are counted, or whether the tool is dividing days by an average month instead of counting anniversaries at all. Find which convention each tool uses and the disagreement almost always explains itself.

Is dividing the days by 30 close enough for months?

No. A real month averages 30.436875 days, so dividing by 30 overstates every month by about half a day, always in the same direction. Over a 36-month span the shortcut invents more than two weeks. If a decimal estimate is genuinely all you need, divide by 30.436875 - and for anything with dates attached, count anniversaries instead.

Why did my spreadsheet say 3 months when the answer is 2 months and 30 days?

Most likely the formula counted month names rather than anniversaries - for example by subtracting MONTH values, or by using a year-fraction function and multiplying by 12. Those methods see January to April as 3 month boundaries crossed and report 3. DATEDIF with the M unit counts completed anniversaries and reports 2, with the MD unit showing the 30 leftover days your formula dropped.

How can I check a month count quickly?

Add it back. Start date plus the full months, plus the leftover days, must land exactly on the end date. Then sanity-check the day total: count the days in the span and confirm the month answer is plausible for it - five months, for instance, always holds between 150 and 153 days. A count that fails either check has an error in it, and the error is usually one of the six in this guide.

Related guides

Full months vs partial months - how to read the answer

The two-part answer that prevents mistake number one.

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

Clamping, chaining and the vanishing 31st.

The average month - why 30.44 days is used and when it misleads

When the division shortcut is acceptable, and when it is not.

How to calculate months between dates in Excel with DATEDIF

The spreadsheet method that avoids the formula traps.

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.