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]

Look at Rob's response here

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

[sunny_talwar]

Something like this

=(Year(MakeDate(2018, 4, 25)) * 12 + Month(MakeDate(2018, 4, 25))) - (Year(MakeDate(2016, 2, 11)) * 12 + Month(MakeDate(2016, 2, 11)))

[sujit_nath]

I'm doing that in backend

[sunny_talwar]

This applies on the back end or front end

[sujit_nath]

Isn't there an easier way?

[sunny_talwar]

What is so difficult about the above syntax?

[sujit_nath]

Does this take into consideration leap years?

[sunny_talwar]

Are we talking about Month difference or Day Difference? How does Day play any role when determining the difference in Month... I am not sure I understand... from the two dates that you provided... what is your expected output?

[sujit_nath]

I want that if it is more than 12 months it should put something after decimal, ie. 12.xyz..

If it's less than 12 as well, it should show in decimals, ex: a difference of 2 months 15 days should show as 2.5 etc.