Excel - Number of calendar months
Posted on 2014-10-18
I would really appreciate help with how to calculate the number of whole calendar months between 2 dates.
For example, if the start and end dates are 1 May 2012 - 31 March 2013, I would expect the result to be 11.
But if the start date is 2 May 2012 instead of 1 May 2012, the result should be 10.
It would be very good if I could also deal with leap years. So if the end date was 28 February 2012, the month of February would not be included in the result. But it would be if the end date was 29 February 2012.
Thank you very much in advance