# How to Calculate Number of Months Between Dates in Google Sheets

To calculate the number of months between two dates in Google Sheets, you can use the `DATEDIF`

function. This function calculates the difference between two dates in years, months, or days.

Here's a step-by-step guide on how to do this:

- Open a new Google Sheet.
- In cell A1, enter the start date (e.g.,
`1/1/2021`

). - In cell B1, enter the end date (e.g.,
`12/31/2021`

). - In cell C1, enter the following formula:
`=DATEDIF(A1, B1, "M")`

. - Press Enter. The result will be the number of months between the two dates.

## Example

Let's say you want to calculate the number of months between January 1, 2021, and December 31, 2021.

- In cell A1, enter the start date:
`1/1/2021`

. - In cell B1, enter the end date:
`12/31/2021`

. - In cell C1, enter the formula:
`=DATEDIF(A1, B1, "M")`

. - Press Enter.

The result in cell C1 will be `11`

, which is the number of months between January 1, 2021, and December 31, 2021.

Did you find this useful?