Months Between Dates: Your Questions Answered
These are the questions people ask most often about months between dates. Each answer is short; follow the links for the full detail.
What does a months between dates calculation tell me?
Counts complete calendar months between two dates.
What is the formula?
Months = year difference × 12 + month difference, minus 1 if the end day is earlier.
What do I need to enter?
Start date, End date.
Does this count Singapore public holidays?
No. It counts calendar days or weekdays. Subtract any public holidays in the period yourself.
Can you show an example?
For example, with these inputs:
- Start date: 15 Mar 2024
- End date: 5 Oct 2026
the calculator returns:
- Complete months: 30 months
Any tips?
- Write dates in an unambiguous format such as 5 Oct 2026 when sharing deadlines.
- Convert times to minutes before subtracting, then convert back to hours and minutes.
- Public holidays are not weekends; subtract them separately when counting working days.
Background
When sharing dates internationally, write the month as a word to avoid confusion between day-month and month-day formats.
Time durations are easier to handle in minutes. Convert each time to minutes after midnight, subtract, then convert back to hours and minutes, adding 24 hours for shifts that run past midnight.
The Gregorian calendar has months of 28 to 31 days and adds a leap day almost every four years, which makes counting days by hand surprisingly error-prone. Converting dates to day numbers and subtracting avoids the problem.
Related calculations
- Age Calculator: Calculates exact age in years, months and days.
- Days Between Dates Calculator: Counts days between two dates.
- Add Days to a Date Calculator: Finds the date a number of days after another date.
- Subtract Days from a Date Calculator: Finds the date a number of days before another date.
Try it yourself with the Months Between Dates Calculator.
Run your own numbers: Months Between Dates Calculator