## Calculate Months with this Handy Excel Formula

Learn how to calculate the number of months between two dates in Excel with the “Months” formula. Understand the syntax of the formula and how it can be used for more than two dates. A beginner's guide to working with dates in Excel.

### Tired of nonsense pricing of DocuSign?

Start taking digital signatures with BoloSign and save money.

Working with dates in Excel can be complicated and time consuming. Luckily, there are Excel formulas that can make it easier. One of the most useful formulas is the “Months” formula, which can be used to calculate the number of months between two dates.

The syntax for the “Months” formula is =MONTHS(Start Date, End Date). The Start Date and End Date are the two dates for which you want to calculate the number of months between. Both date values should be entered as text strings, enclosed in quotation marks. For example, if you wanted to calculate the number of months between January 1, 2020 and April 30, 2020, you would enter =MONTHS("1/1/2020","4/30/2020").

The “Months” formula will return the number of months between the two dates, including partial months. For example, if you enter the above dates, the formula will return 3, because there are 3 full months between those two dates. It will also work with more than two dates, returning the number of months between the first and last dates specified.

In addition, the “Months” formula will also take into account leap years when calculating the number of months. This means that if two dates span a leap year, the formula will accurately calculate the number of months between them, even if the start and end dates do not fall on the same day of the year.

In conclusion, the “Months” formula is a handy tool for quickly calculating the number of months between two dates in Excel. By understanding how to use this formula, you'll be able to easily analyze and compare dates in your spreadsheets.

### Paresh Deshmukh

Co-Founder, BoloForms

30 Jan, 2023

## Take a Look at Our Featured Articles

These articles will guide you on how to simplify office work, boost your efficiency, and concentrate on expanding your business.