(...)*12+(...)
Calculate 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)
0
The formula takes the difference of years and converts into month and then add the difference of months to reach the final month count.