Hello,
I have a formula for a Calendar calculation that takes (MONTH($AB9)-MONTH($AA9)) and gives me the number of months. AB and AA would have dates in them. 1/1/2012 - 6/30/2012 etc. When I save the file over for Fiscal calculations the formula breaks because my fiscal date is 7/1/2013 - 6/30/2014. I end up getting a negative 1. Can anyone help me figure out a formula so that regardless if it is a calendar or fiscal file it will calculate the number of months between the two dates resulting in a positive number? The negative number is messing with my count. I can't use an ABS in the formula because 6/30/2014 minus 7/1/2013 would still give me 1 and I need it to give me 12.
Any help is much appreciated.
Bookmarks