(...)*12+MONTH(...)-MONTH(...)
Calculate number of months between two dates
Used Functions
Category: Date and time
Converts a serial number to a year
Syntax
YEAR(serial_number)
Practice YEAR Formula at Sheetzoom
YEAR formula at Microsoft helpCategory: Date and time
Converts a serial number to a month
Syntax
MONTH(serial_number)
1
To calculate the number of months between two date, we need to take the difference of month and years between the dates, and multiply year with 12 to get the months, we finally add up both to get the month count.