Please enable JavaScript to view the comments powered by Disqus.


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

Count months between two dates

The formula calculates the difference between start and end month to find months,  then it takes the difference of years and converts it months as well and then adds both to get the final count.


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