diff in month betweeen two dates

[souadouert]

I have two date 20180130 - 20180228  and i need to calculate the number of months between two date  in straight table (CHART)
so in my example i have to find  1 MONTH

[tresesco]

First convert the dates using date# with proper format like: Date#( Date1, 'YYYYMMDD') and then follow one method like shown here:

How Do I Get the Number of Months Between Two Dates?

Calculating Months difference between two dates

[sasiparupudi1]

Interval(Date#('20180228','YYYYMMDD')-Date#('20180130','YYYYMMDD'),'d')

[sasiparupudi1 · Accepted solution]

(Year(Date#(20180228,'YYYYMMDD'))*12+Month(Date#(20180228,'YYYYMMDD')))

-

(Year(Date#(20180130,'YYYYMMDD'))*12+Month(Date#(20180130,'YYYYMMDD')))