I have two columns one for start date and one for end date. I am try to an automatic calculation of the months between the to dates. However if the start date is 15th or after it counts as the next month (example 01/15/16 would count as February).
I was thinking an if formula if the start date is days 1:14 than
IF(D6<14,(year(e6)-year(d6))*12+month(e6)-month(d6),(year(e6)-year(d6))*12+month(e6)-month(d6)+1). but I cannot get it to work.
Any other suggestions?