Home / Calculators / Months between dates

Months Between Dates

Find the number of months between two dates in the way you need: complete months and days, decimal months, calendar months touched, or 30/360 months.

Why there is more than one answer

Months are not all the same length, so there is no single correct number of months between two dates. The right method depends on what you are counting. This tool shows the common ones next to each other.

The methods

MethodWhat it givesUsed for
Complete months and daysWhole months, then the days left overLease and contract length, subscriptions, age in months
Decimal months (calendar)Whole months plus the part of the next month that has passedPro-rata amounts
Decimal months (average)Days divided by 30.4375, the average length of a monthQuick estimates
30/360 monthsEvery month has 30 days and a year has 360Interest and bond calculations
Calendar months touchedHow many different months the period includesBilling by calendar month

Complete months

The tool adds whole months to the start date and stops before it passes the end date. From 15 January to 14 March is 1 month and 27 or 28 days, because the second full month ends on 15 March. When the start day does not exist in a month, such as the 31st, the last day of that month is used. This matches the whole months that the Excel function DATEDIF gives with the unit m.

30/360

The 30/360 method is used in finance. It treats every month as 30 days. The tool uses a simplified US form of the rule: a start day of 31 becomes 30, and an end day of 31 becomes 30 when the start day is 30 or more. Contracts specify the exact convention, so check yours.

Include the end date

Tick Include the end date to count the last day as part of the period. This adds one day before the months are worked out.

Related calculators

See date difference for years, months and days, days between dates for days, and weeks between dates. For percentages of a period use the percentage change calculator. The guide shows the formulas.

Frequently asked questions

How many months are between two dates?

It depends on the method. The tool shows complete months and days, decimal months, calendar months touched and 30/360 months.

What is the average length of a month?

About 30.44 days, which is 365.25 divided by 12. The tool uses 30.4375 for the average method.

How does Excel count months between dates?

DATEDIF with the unit m gives complete months, which matches the complete months in this tool.

What is the 30/360 method?

A finance convention that treats every month as 30 days and a year as 360 days.