Number of Months between two Dates

[qadirm28]

Hello everyone,

I used this formula to calculate the number of months between two dates in a table. But, it shows a negative value, although the last date is higher than the first date.

Month(Date#(Max([Date Meeting]),'YYYY-MM-DD'))-Month(Date#(Min([Date Meeting]),'YYYY-MM-DD'))

[BrunPierre · Accepted solution]

Hi, I'd rather you do this.

((Year(Date#([Date Last Meeting Minutes],'YYYY-MM-DD'))*12)+Month(Date#([Date Last Meeting Minutes],'YYYY-MM-DD'))) - (((Year(Date#([Date First Meeting Minutes],'YYYY-MM-DD'))*12)+Month(Date#([Date First Meeting Minutes],'YYYY-MM-DD'))))