How to use this months between dates calculator
Enter the earlier date as the start date and the later date as the end date, then press Calculate months between. If the dates go in the other way round, the tool swaps them and tells you it did so, because a month count is about the size of the span, not its direction. The Today buttons are the quick way to answer questions like how many months since a baby was born, how many months are left on a lease, or how long a job has lasted so far.
Try it with January 15, 2026 and July 15, 2026. The answer is exactly 6 full months and 0 remaining days, because the 15th of July is the same day of the month as the 15th of January - six complete month boundaries have been crossed and nothing is left over. Move the end date five days later, to July 20, and the answer becomes 6 full months and 5 days. That pair of examples shows the whole method: complete months first, counted on the real calendar, then the leftover days counted on their own. The timeline under the result draws the same thing as blocks, one block per full month and a shorter block for the remainder.
The three ways to read the answer - and why people argue about them
Ask three different tools how many months sit between two dates and you can get three different answers, all from honest arithmetic. The disagreement is not about the dates; it is about what the word "month" is taken to mean. This calculator shows all three readings at once, labelled, so the argument ends here.
Reading 1: full calendar months plus remaining days. This is the headline answer. A month counts as complete only when the same day of the month comes round again, and anything short of that is reported as days. It is the method leases, ages, notice periods and employment records use, and the method Excel's DATEDIF uses. It never rounds a partial month up, which is why it sometimes looks stricter than other tools.
Reading 2: total months as one whole figure. The same calendar count with the years folded in - years times 12 plus the remaining whole months. A span of 1 year, 3 months and 19 days is "15 months" in this reading. Forms and contracts that ask for a length in months usually want this figure, with the leftover days stated separately if they matter.
Reading 3: decimal months from the average month. Divide the total days by 30.436875, the average length of a month, and you get a decimal such as 15.64. This reading is labelled approximate on this page, because it is one - no real month lasts 30.436875 days. It is handy for statistics, interest estimates and very long spans, and misleading for short ones, as the section on the average month below explains.
| Reading | March 15, 2025 to July 4, 2026 | Best for |
|---|---|---|
| Full months plus remaining days | 15 full months and 19 days | Leases, ages, service records, anything quoted to another person |
| Total months, one whole figure | 15 months (1 year, 3 months), 19 days past the mark | Forms, contracts and comparisons that ask for months only |
| Decimal months (average month) | 15.64 months, approximate (476 days / 30.436875) | Statistics, rough planning, interest estimates |
Notice that readings 1 and 2 agree on the whole months and differ only in how the answer is packaged, while reading 3 is a genuinely different number. If a count from another site disagrees with this page by a fraction of a month, reading 3 is almost certainly what it used.

Why months are the hardest unit on the calendar
Days and weeks behave themselves. A day is a day, a week is always seven days, and counting them is simple subtraction. A month is none of that. Months run from 28 to 31 days, the pattern of lengths is irregular - July and August sit side by side with 31 days each, while February stops at 28 or 29 - and there is no tidy rule a person can apply in their head beyond the knuckle trick for remembering which months are long.
The deeper problem is that a month is a position on the calendar, not a fixed stretch of time. "One month after January 15" clearly means February 15, and everyone agrees. But "one month after January 31" has no exact answer, because February has no 31st day. Any tool, spreadsheet or contract that counts months has to take a position on cases like that, and different positions produce different totals. Software usually clamps the date to the end of the shorter month, so one month after January 31 becomes February 28. That is sensible, but it means the next step lands on March 28, not March 31 - the original day of the month is lost, and counts drift.
This is why month counts start more arguments than day counts ever do. A landlord, an HR department and a new parent can each count the same span three ways and each be following a real convention. The fix is not a cleverer formula; it is stating the method next to the number, which is what this page does.
Full months, partial months and the January 31 problem
The calendar method on this page counts a month as full only when the same day of the month is reached again, and it borrows days from the month before the end date when the end day is smaller than the start day - the remaining-days method, the same one DATEDIF uses in Excel. Month-end clamping is where this method shows its character. January 31 to February 28 reads as 0 full months and 28 days: the span is four weeks long, but no complete month boundary has been crossed, because February never offers a 31st for the month to complete on. Some tools round the average-month figure and call that span one month. We think that is the wrong answer to give for rent, notice or a baby's age, so the headline here stays at 0 full months, with the decimal reading (0.92) shown alongside for anyone who wants it.
| Span | Calendar reading | Why |
|---|---|---|
| Jan 31, 2026 to Feb 28, 2026 | 0 full months, 28 days | February has no 31st, so no month completes |
| Jan 31, 2026 to Mar 31, 2026 | 2 full months, 0 days | The same day of the month at both ends |
| Mar 31, 2026 to Apr 30, 2026 | 0 full months, 30 days | April has no 31st either |
| Oct 31, 2026 to Nov 30, 2026 | 0 full months, 30 days | November stops at 30 days |
The practical rule: when a span starts on the 29th, 30th or 31st, expect the calendar count to look one month lower than a quick guess, and check whether your contract, tenancy agreement or HR policy counts that span the same way before you rely on the number. Our guide on month-end dates works through the January 31 problem in full, and the guide on full months vs partial months shows how to read answers like these.
The average month - 30.436875 days, explained honestly
The decimal reading needs an average month, and the honest average comes from the Gregorian calendar itself. A Gregorian year averages 365.2425 days: 365 ordinary days, plus 97 leap days spread across each 400-year cycle (years divisible by 4 are leap years, except century years, which are leap only when divisible by 400 - so 2000 was a leap year and 2100 will not be). Divide 365.2425 by 12 and the average month is 30.436875 days. That is the figure behind the decimal result on this page, and close cousins of it (30.44, or a flat 30) appear in interest calculations, statistics and many other calculators.
An average is a summary, not a measurement, and it misleads in predictable places. February 1 to March 1, 2026 is exactly one calendar month, but it holds only 28 days, so the average method calls it 0.92 months. July 1 to August 1 is also exactly one calendar month, but it holds 31 days, so the average method calls it 1.02 months. Same true answer - one month - two different decimals, neither of them 1.00. The shorter the span, the bigger this wobble, and spans that sit inside a single February or a pair of 31-day months are the worst cases. Over years, the errors cancel out and the decimal becomes genuinely useful: for a ten-year span it is a fair summary, and for comparing two long periods it is often the cleanest number available. Just never quote it to a landlord as the length of a tenancy.

Where an honest month count matters
Leases and contracts. Tenancies, notice periods and contract terms are written in months, and the money turns on the count. A six-month lease starting on August 31 runs into the February clamping problem at its far end, and whether the term is read as ending on February 28 or March 1 is worth real money. Counting on the calendar method, and saying so, keeps both sides honest.
A baby's age. Parents count in months for the first two years, and health visitors do too. Everyday speech is generous here - a baby born on January 31 is often called one month old on February 28 - but the calendar count says 0 full months and 28 days, and forms that ask for age in completed months want the calendar count. Our guide on counting months for a baby's age covers the conventions clinics use.
Employment and service. Probation periods, notice periods, long-service milestones and benefits that unlock after a set number of months all run on completed calendar months from the start date. Someone who started on March 15 completes three months of service on June 15, not on some average-month date in between. The months of service guide shows how HR departments count it.
Loans, interest and subscriptions. Lenders quote terms in months but charge interest by the day, which is why the decimal reading exists at all: for pricing, the average month is a reasonable bridge between the two. Subscription and billing cycles are simpler - they usually run on the same day of each month, clamped at month ends - and a calendar count tells you how many full cycles sit inside any span.

Months between dates in Excel and Google Sheets
In a spreadsheet, the calendar method lives inside one old function: DATEDIF. It is a compatibility function left over from Lotus 1-2-3, which is why Excel does not list it in the formula helper - you have to type it in full. Put the start date in A1 and the end date in B1. =DATEDIF(A1,B1,"m") returns the complete months, the same headline figure this calculator gives. The function's real power is its six units, which split a span into any combination of years, months and days:
| Unit | Returns | Typical use |
|---|---|---|
"y" | Complete years in the span | Age in years, years of service |
"m" | Complete months across the whole span | Total months of a lease, loan or contract |
"d" | Total days in the span | The raw day count, same as simple subtraction |
"ym" | Months left over after the complete years | The months part of "2 years, 5 months" |
"md" | Days left over after the complete months | The days part of "2 years, 5 months, 11 days" |
"yd" | Days left over after the complete years | Where a date falls inside its current year of the span |
Combining "y", "ym" and "md" in three cells rebuilds the full years-months-days breakdown. Two warnings from experience: DATEDIF complains if the start date is later than the end date, and Microsoft itself notes that the "md" unit can return a wrong or negative figure in rare month-end cases in Excel - exactly the January 31 territory described above - so sanity-check month-end spans. Google Sheets supports DATEDIF with the same six units and the same syntax. Our guides on months between dates in Excel and months between dates in Google Sheets work through complete examples, and the DATEDIF units guide explains each unit on its own.
Common mistakes when counting months
Three mistakes account for nearly every wrong month count. The first is assuming a month is four weeks: four weeks is 28 days, shorter than every month except February, so a "monthly" cycle counted in weeks drifts by two or three days a month and by weeks across a year. The second is rounding a partial month up because it feels close - a span of 5 months and 29 days is not 6 months for notice, rent or service purposes until the sixth month actually completes. The third is trusting the average month on a short span, where February and the 31-day months can push the decimal a full tenth of a month away from the calendar truth. If a count matters, use the calendar method, state it, and keep the leftover days in the answer where everyone can see them.
Frequently asked questions
How do I calculate the months between two dates?
Enter the start date and the end date and press Calculate. The calculator counts complete calendar months first - from a day of one month to the same day of a later month - then counts the days left over. January 15 to July 15 is exactly 6 full months with nothing left over, while January 15 to July 20 is 6 full months and 5 days.
Why do different calculators give different answers for the months between dates?
Because a month is not a fixed number of days. Calendar tools count full calendar months and leftover days, which is how leases, ages and employment records work. Other tools divide the total days by the average month length of 30.436875 days, which produces a decimal that can sit above or below the calendar answer. This page shows both methods, clearly labelled, so you can use the one your situation calls for.
Is January 31 to February 28 one month?
By the calendar method used here, no. It is 0 full months and 28 days, because February 28 is not the same day of the month as January 31 and no complete month has passed. Tools that use the average month may call it roughly one month. For rent, notice periods and ages, the calendar method is the safer one to quote.
What is the average length of a month?
The average month is 30.436875 days. It comes from the Gregorian calendar year of 365.2425 days - 365 days plus 97 leap days spread over 400 years - divided by 12. It is a fair average for long spans and statistics, but no real month has that length: real months run from 28 to 31 days.
How do I calculate months between dates in Excel?
Use the DATEDIF function. =DATEDIF(A1,B1,"m") returns the complete months between the dates in A1 and B1. Combining it with the "ym" unit (months left after whole years) and the "md" unit (days left after whole months) gives the full breakdown. Google Sheets supports DATEDIF with the same units, and the Excel section above explains all six units.
What does the include end date option do to a month count?
It adds one day to the span before the months are counted. That day lands in the remaining days, and now and then it tips a nearly complete month into a full one. Use it when your situation counts both the first and the last day, as some leave and tenancy arrangements do; leave it off for ages, deadlines and service records.
