Months Calculator — Count Months Between Dates, Add/Subtract Months & More

What is a months calculator?

A months calculator answers one of the most common date questions: how many months is that? Whether you are figuring out how long a lease has left, how old your baby is, how many months until a project deadline, or how far you are into a relationship, the answer is rarely just "count the months on a calendar" — because months vary from 28 to 31 days, leap years add an extra day every four years, and end-of-month edge cases (like January 31st) have no clean monthly anniversary.

This tool handles all of that math for you, across five distinct modes. Rather than force every use case through a single "start date / end date" form, the calculator gives you the right interface for what you're actually trying to measure — counting months between dates, adding or subtracting months from a date, finding the date N months from today, tracking a monthsary, or calculating age in months.

Every mode shares the same strict date arithmetic under the hood. That means a "6 months" result from this tool is identical to what Excel's EDATE function, JavaScript's date libraries, and most payroll systems would produce. No round-ups, no approximate day-count, no "about 5 months" guesses.

💡 Interactive calendar heatmap. Unlike most months calculators, every day in the range is visualized on a calendar. Hover any day to see its exact date, weekday, and cumulative position in the range. Click any day to set it as your start or end date. Whole months are shown in solid color, partial months in a lighter shade, so you can literally see how the count is built up.

The five modes explained

1. Months between dates

The classic calculation. Enter a start date and an end date, and the tool tells you how many full calendar months lie between them, plus the remaining days. This is the mode most users come for — for rental leases, subscription periods, employment tenure, project timelines, and anything else where "how many months?" is the question.

Six different visualizations and details appear at once:

• Live result card — the strict answer ("11 months, 30 days") in large numerals, updated on every keystroke.
• Method comparison — three cards showing the same date range calculated three different ways (Clamped, Strict, Calendar-touched) so you can see how the conventions diverge.
• Interactive timeline — hover any tick mark to see details, click a tick to jump to that month.
• Calendar heatmap — every day in the range highlighted, with leap days visually distinguished and days clickable to reset start/end.
• Secondary stats — total days, weeks, weekends, weekdays, decimal months, years/months/days breakdown.
• Month-by-month table — expand to see each month in the range with its day count and cumulative running total.

Below that, the tool offers preset ranges (This month, Last month, This quarter, Last quarter, Year to date, This year, Last year) for common reporting periods, plus a full set of settings (Include end day, counting method). Export as CSV, JSON, Markdown, or PNG.

2. Add or subtract months from a date

Enter a start date and a number of months, choose Add or Subtract, and the calculator returns the target date. This is the "what is 6 months from today?" mode — useful for lease endings, warranty expiry, notice periods, contract renewals, and any date that is defined as "N months from now."

The key feature is end-of-month clamping. If you start on January 31st and add one month, you cannot have "February 31st" — so the calculator returns February 28th (or February 29th in a leap year). This is the standard behaviour of Excel's EDATE function, JavaScript's date libraries, and most payroll systems. When clamping occurs, a dedicated visualization panel appears showing exactly what you asked for (Jan 31 + 1 month) with the invalid February 31st crossed out, next to what you actually got (Feb 28) — so you can visually confirm the tool did the right thing.

3. From today with live countdown

A streamlined version of the offset mode for the most common case: "N months from today" or "N months ago from today." No start date to pick — the calculator uses today's date automatically. Nine preset buttons (1, 3, 6, 9, 12, 18, 24 months from now, plus 6, 9, 12 months ago) cover the vast majority of real-world uses.

The live countdown updates every second, showing the exact days, hours, minutes, and seconds until (or since) the target date. A progress bar shows how far through the span you are. This is perfect for deadline tracking, celebrations, lease expirations, and any countdown where "how many days left?" matters. The countdown pauses when the tab is not visible and resumes automatically when you return.

4. Monthsary with year ring

A monthsary is the monthly anniversary of a milestone date — the same day-of-month every month. If your relationship started on March 6th, your first monthsary is April 6th, your second is May 6th, and so on. Unlike a "monthly" duration (which is 30 or 31 days), a monthsary is a calendar anniversary — it falls on the same day-of-month every month regardless of how many days the month has.

The monthsary mode counts how many months you have been together, shows the next monthsary date with a live countdown, and displays all 12 upcoming monthsaries on a circular year ring — a visual where each month is positioned around a circle, with your monthsary dates highlighted. The ring makes it easy to see patterns at a glance (e.g., "our monthsary always falls in the last week of the month"). Below the ring, a grid of 12 cards lists every upcoming monthsary with its number, date, and day of the week. Click any card to jump to that date. This is especially useful in Philippine and Asian relationship cultures, but the math works for any recurring monthly milestone — work anniversaries, pet birthdays, sobriety milestones, and so on.

5. Age in months with sub-period breakdown

For babies, toddlers, and pregnancy tracking, age is often measured in months rather than years. A pediatrician tracking development asks "how many months old is the baby?" — not "how many years." This mode takes a birth date (or start date) and an "as of" date (defaulting to today) and returns the age in total months, plus the exact years/months/days breakdown.

The sub-period progress bars at the top of the result show three separate progress indicators: how far through the current year, how far through the current month, and how far through the current day. This gives a richer sense of age than a single progress bar. Below the bars, milestone dots mark the 1, 6, 12, 18, 24, and 36-month developmental checkpoints that pediatricians use. For children under 24 months, the calculator also shows age in weeks and days — the standard measure pediatricians use for the first two years.

How month calculations actually work

Months are not a fixed unit. January has 31 days, February has 28 (or 29), March has 31, April has 30, and so on. This means "how many months between two dates?" has multiple valid answers depending on the convention you use. The most common conventions are:

Full months (clamped)

Count complete calendar months elapsed, with end-of-month clamping. If you start on January 15th, you complete one full month on February 15th, two full months on March 15th, and so on. If you start on January 31st, you complete one month on the last day of February (Feb 28 or Feb 29) even though February 31st doesn't exist.

This is what Excel's EDATE function does, and what most payroll, billing, and contractual systems use. It's the tool's default convention because it matches what most people intuitively expect.

Strict anniversary

Count complete months only when the end date's day-of-month has reached the start date's day-of-month. If you start on January 31st, February 28th does not count as a full month because February 31st doesn't exist — you have to wait until March 3rd (or later) to complete "one month" using strict anniversary logic.

Some accounting systems use this convention because it avoids the ambiguity of clamping. But it produces counter-intuitive results for month-end dates, which is why most modern tools default to clamping.

Calendar months touched

Count every month bucket the span enters. From March 15th to July 4th, the span touches March, April, May, June, and July — five calendar months — even though only three full months have elapsed. This is the convention many billing systems use for invoicing (each month you are "using" the service counts as one billing month).

The tool offers this as a dropdown option in the Between Dates mode, and shows all three conventions side-by-side in the comparison panel. If you are doing subscription billing or prorating rent, use calendar-months-touched.

Decimal months (for prorating)

Divide the total days by the average Gregorian month of 30.4369 days. This is the right measure for prorating costs over a fractional month: if a service costs $60/month and you used it for 15 days, the prorated cost is 60 × (15 ÷ 30.4369) ≈ $29.57.

The calculator shows decimal months alongside the full-months result in the secondary cards, so you have both numbers available.

Month lengths and leap years

Not all months are the same length. Here's the full table for reference:

A common year has 365 days; a leap year has 366 days because February has 29 days instead of 28. Leap years follow a simple rule: any year divisible by 4 is a leap year, except century years (like 1900 or 2100) which must be divisible by 400. So 2000 was a leap year, 1900 was not, and 2100 will not be.

The calculator handles leap years automatically, and visually highlights February 29th with a distinct color on the calendar heatmap whenever your span crosses a leap year. If the start date is February 29th and the target month has no 29th (like February of a non-leap year), the target date is clamped to February 28th.

End-of-month clamping explained

Clamping is what makes calendar arithmetic feel natural. If you ask "what is one month from January 31st?", there is no February 31st to return. Rather than error out or return a nonsense date, the calculator clamps to February 28th (or February 29th in a leap year). This is what everyone expects — and it's what Microsoft Excel's EDATE, Google Sheets' EDATE, JavaScript libraries like date-fns, and most payroll systems do.

Here are some common clamping examples:

• January 31 + 1 month = February 28 (or February 29 in a leap year)
• March 31 + 1 month = April 30
• May 31 + 3 months = August 31 (no clamping — August has a 31st)
• March 31 − 1 month = February 28 (or February 29)
• August 31 + 6 months = February 28 (or February 29)
• February 29 + 12 months = February 28 of the next year (clamping in a non-leap year)

Whenever clamping happens, the tool shows a side-by-side comparison in an amber panel: on the left, what you asked for (with the invalid day crossed out); on the right, what you got; and a note explaining exactly which day was clamped. This is a visual confirmation that the tool did the right thing.

Comparing the three methods

The method comparison panel in Between Dates mode is the single most useful feature of this tool — no other months calculator shows all three conventions side-by-side. For any given start and end date, the panel shows:

The delta badge on each card shows how that method's answer differs from the currently-selected method, so you can immediately see "this method says 1 month fewer" or "this method says 0 months more." This resolves the confusion that most months calculators leave unaddressed — the answer depends entirely on which convention your spreadsheet, contract, or billing system uses, and this tool lets you see all of them at once.

Worked examples

Example 1: A standard 12-month lease

A tenant signs a lease starting September 1, 2025 and ending August 31, 2026. Using the Between Dates mode:

• Full months (clamped): 11 months and 30 days
• Calendar months touched: 12 months (September through August)
• Total days: 364 days
• Weekdays / weekends: 260 weekdays, 104 weekend days
• Total weeks: 52 weeks

Legally this is a 12-month lease, and most landlords bill 12 monthly payments. But strictly speaking, September 1 to August 31 is 11 months and 30 days because August 31 is the day before the 12-month anniversary. If the lease ended September 1, 2026 instead of August 31, the strict calendar answer would be exactly 12 months. This is why leases usually say "ending August 31" — the one-day difference is intentional and makes the term feel complete.

Example 2: A baby's age in months

A baby is born on January 15, 2024, and today is January 20, 2026. Using the Age in Months mode:

• Age in months: 24 months and 5 days
• Years + months + days: 2 years, 0 months, 5 days
• Total weeks: 104 weeks and 5 days
• Total days: 736 days
• Progress toward 25 months: 16% through the current month

At this age, most pediatricians switch from counting in months to counting in years — but for tracking developmental milestones, the 24-month mark is an important checkpoint (the CDC and AAP use 24 months as the last major milestone window). The sub-period progress bars show all three levels at once: 100% through the second year, 0% through the third, and 16% through the current month.

Example 3: Six months from now

If today is January 15, 2026, and you want to know the date six months from today:

• Target date: July 15, 2026
• Day of week: Wednesday
• Days between: 181 days

Notice that 6 months is 181 days in this case, not 180 or 182. That's because the 6-month span from January 15 to July 15 covers January (31), February (28), March (31), April (30), May (31), and June (30) — totaling 181 days. The From Today mode shows this with a live countdown that updates every second, and a progress bar showing how far through the 181 days you are.

Example 4: A monthsary on the 15th

A couple started dating on March 15, 2024. Today is August 20, 2025. Using the Monthsary mode:

• Total months together: 17 months and 5 days
• Next monthsary: September 15, 2025
• Days until next monthsary: 26 days

Because their relationship started on the 15th of the month, their monthsary always falls on the 15th. The year ring shows all 12 upcoming monthsaries positioned around a circle with the current month highlighted, making it easy to see at a glance when the next one falls.

Example 5: A warranty that runs "6 months from purchase"

A laptop purchased on March 31, 2026 has a 6-month warranty. Using the Add mode:

• Warranty ends: September 30, 2026 (clamped from September 31 to September 30, because September has only 30 days)
• Total months: 6 months, 0 days (using the clamped convention)
• Days covered: 183 days

The clamping panel shows "What you asked for: March 31 + 6 months = September 31" with September 31 crossed out, next to "What you got: September 30, 2026." A note below explains: "September has only 30 days. Day 31 was clamped to 30."

How to calculate months in Excel and Google Sheets

If you need the calculation to live inside a spreadsheet rather than a browser tool, here are the formulas that match this calculator's behaviour:

⚠ Important DATEDIF gotcha. Excel's DATEDIF does not use clamping. If you enter January 31 to February 28, DATEDIF returns 0 months, not 1. This is because February 31st doesn't exist for the anniversary to land on. The calculator in this tool defaults to clamping, which gives the more intuitive answer of 1 month. If you need to match DATEDIF's exact behaviour, choose the "Strict anniversary" option in the Between Dates mode — or check the comparison panel to see both answers side by side.

Use cases by context

Real estate and leasing

Lease terms are almost always expressed in months. Whether you are a landlord verifying a 12-month term, a tenant checking the days remaining, or a property manager calculating a pro-rated first-month rent, the calculator handles all three. The "Calendar months touched" option is what you want for billing; the "Full months (clamped)" option is what you want for the contractual term. The preset "This year" and "Last year" buttons make it easy to jump to annual accounting periods.

Employment and HR

Employee tenure is commonly measured in months, especially for benefits eligibility (90-day probationary periods, 6-month review cycles, 12-month vesting schedules). Enter the hire date and today's date in the Between Dates mode to get tenure in months and days. The tool also works in reverse: "when is this employee's 12-month anniversary?" is an Add mode calculation from the hire date. Weekday counts (from the secondary cards) tell you how many business days of actual work the tenure covers.

Billing and subscriptions

Subscription services bill in months, and proration depends on the exact number of days in the billing period. The calculator shows both the calendar months (for counting billing cycles) and the decimal months (for prorating charges within a cycle). The comparison panel is especially useful when the billing system's answer differs from what the customer expected — you can point at "Strict anniversary" and say "this is why your bill was 0 months instead of 1."

Pregnancy and early childhood

Pregnancy is tracked in weeks and trimesters, not months — but many expecting parents want a rough "how many months am I?" answer. Using the LMP (last menstrual period) as the start date and the current date as the end date in the Between Dates mode gives a calendar-month answer. For babies, the Age in Months mode gives the pediatric-month count that doctors use for developmental milestones, with milestone markers at 1, 6, 12, 18, 24, and 36 months.

Relationships and milestones

Monthsaries are especially important in Filipino and many Asian relationship cultures, where couples celebrate the same day-of-month every month. The Monthsary mode counts the total months together, shows the next monthsary date with a countdown, and displays all 12 upcoming monthsaries on a year ring. It also works for work anniversaries, pet birthdays, sobriety milestones, and any other monthly recurring event. Export as CSV to save the full schedule.

Project management

Deadlines and project timelines are often expressed in months ("this project must be delivered in 6 months"). The Add mode lets you enter a kickoff date and a month count to get the target delivery date, while the Between Dates mode tells you how many months you have remaining from today. Both together cover the full project lifecycle. The weekday count is especially useful — 6 calendar months is not the same number of working days as 3 months plus 3 months, because weekends don't fall evenly.

Legal and financial

Contract durations, statute-of-limitations windows, and loan terms are all measured in months. The calculator uses strict calendar arithmetic — no approximations, no rounding — which matches the way Excel and legal date calculations work. The comparison panel is the key feature here: when a contract says "24 months" and your spreadsheet says "23 months 30 days," you can see both answers side-by-side and quickly figure out which convention the contract actually means.

How to use the calendar heatmap

The calendar heatmap is the signature feature of this months calculator. Every day in your date range is shown as a small colored square on a mini-calendar grid, one month per column. Here's what each state means:

• Solid colored day — fully in range and part of a full month.
• Lighter colored day — partially in range (start or end of the span falls mid-month).
• Amber day — February 29 in a leap year.
• Green border — the start date.
• Purple border — the end date.
• Orange border — today's date (if visible in the range).

Hover any day to see its exact date, weekday, and cumulative position in the range (e.g., "Day 47 of 365").

Click any day to set it as the new start or end date. The tool cycles: the first click sets the new start date (keeping the current end), the second click sets the new end date (keeping the new start), the third click resets the cycle so the next click starts over.

The heatmap scrolls horizontally if the range is more than about 12 months, so you can use it for multi-year spans without it becoming cramped. Leap years are automatically detected and February 29 is highlighted in amber so you can see at a glance whether a leap day is being counted.

Preset ranges for common reporting periods

Seven preset buttons jump straight to the most common reporting periods:

Click any preset and both date inputs are filled instantly. The result, timeline, heatmap, comparison panel, and breakdown table all update to match. The preset buttons are especially useful for financial and HR workflows where you check the same periods repeatedly.

Common mistakes when counting months

• Assuming every month is 30 days. A 6-month span can be anywhere from 181 to 184 days depending on which months it covers. Always use calendar arithmetic, not day-counts.
• Confusing full months with calendar months touched. March 15 to July 4 is 3 full months but touches 5 calendar months. Billing systems use the latter; contracts usually mean the former.
• Letting month-end dates round up. January 31 to February 28 is 0 months in strict anniversary logic — because February 31 doesn't exist — but 1 month in the clamped convention. Know which convention your contract or spreadsheet uses, and use the comparison panel to see both.
• Forgetting leap years when adding months. February 29 + 12 months is February 28, not February 29, unless the target year is also a leap year. The calculator handles this automatically, but manual calculations often don't.
• Including the end day when the convention excludes it. Most legal and financial calculations exclude the end day (June 1 to June 2 is 1 day, not 2). Adding an extra day shifts every downstream calculation.
• Using "months" when the source says "weeks" or "days." A "90-day warranty" is 3 calendar months only if the 3 months total 90 days — usually they don't. Read the source unit carefully.
• Assuming time zones don't matter across the international date line. A calendar date in Tokyo is a different date from the same moment in New York. If your source dates are from different time zones, verify which calendar date each one actually falls on.

Limitations

• This calculator uses the Gregorian calendar — the world's most widely used civil calendar. It does not support the Julian calendar, Hebrew calendar, Islamic calendar, Chinese calendar, or other non-Gregorian systems.
• Date inputs are limited to the standard HTML date range (roughly 0001-01-01 to 275760-09-13 in most browsers), so extremely far-future or historical dates may not be accepted by the browser's date picker.
• The calculator does not account for time zones. All calculations treat dates as local calendar dates without time-of-day components, which is the correct convention for date math but differs from "hours elapsed" calculations across time zones.
• Business day calculations (excluding weekends and holidays) count weekends but not holidays. For holiday-aware business day math, use a dedicated business-day calculator that includes a holiday calendar.
• The pregnancy-month interpretation is a rough calendar approximation. Medically, pregnancy is tracked in weeks from LMP, not in calendar months.
• The tool does not store any of your data on a server. If you need to save a calculation, use the Share button to encode it in a URL, or the Export menu to download as CSV, JSON, Markdown, or PNG.
• The live countdown in From Today mode updates every second while the tab is visible. It pauses when the tab is hidden and resumes when you return — the count still reflects the actual elapsed time.

Frequently asked questions

Related tools on AIToolsPros