Calculate Number of Months Between Dates in Excel & Google Sheets

This tutorial will demonstrate how to calculate the number of months between two dates in Excel & Google Sheets.

Calculate Number of Months Between Main

Number of Months Between Dates

To calculate the number of months between dates you can use the DATEDIF Function:

DATEDIF Dates

Note: the DATEDIF Function rounds down by default. Look at this example:

DATEDIF Month

Nearest Whole Month

Instead, you can add 15 days to the end_date to ensure that the DATEDIF Function rounds to the nearest whole month:

Nearest Whole Month

Number of Months Between Dates in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.

Calculate Number of Months Between Google