Please enable JavaScript to view the comments powered by Disqus.


(...YEAR(...B4)-YEAR(...B3))*12+(...MONTH(...B4)-MONTH(...B3))

Calculate the number of months between two dates

This formula calculate the difference of years by and multiplies it by 12 to get the number of months, then it subtracts the months between the dates and add the count to get the final answer.


Used Functions

Category: Date and time

Converts a serial number to a year

Syntax

YEAR(serial_number)

Category: Date and time

Converts a serial number to a month

Syntax

MONTH(serial_number)

Lets chat on this