Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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