Calculate difference in months between two dates

[sujit_nath]

I have 2 columns in format MM/DD/YYYY

I need to calculate the difference in months between 2 dates.

Ex: 04/25/2018  -  02/11/2016

and so on...

[sunny_talwar · Accepted solution]

May be use this where 30.4 gives a good approximation for the number of days in a month on average.

=(MakeDate(2018, 4, 25) - MakeDate(2016, 2, 11))/30.4

This gives 26.44