Hi,
I was wondering if there is a way to count the number of months that falls within a given range of dates given dates outside those two given dates. I apologize for not explaining clearly, but here is an example:
The start and end dates can change.
Start Date 5/18/2013
End Date 10/31/2015
I need to determine how many months ranging from 11/1/12 - 10/31/13 FY12, etc fall within the start and end dates.
FY12 : 11/1/2012 - 10/31/2013. The formula should return 5.
FY13 : 11/1/2013 - 10/31/2014. The formula should return 12.
FY14 : 11/1/2014 - 10/31/2015. The formula should return 12.
FY15 : 11/1/2015 - 10/31/2016. The formula should return 0.
I was able to create a formula that returns those values, however, if I decide to change the start date and end dates, it doesn't work. i can't come up with a formula that deals with all scenarios. Any suggestions would help! Thanks in advance!
Bookmarks