Enter date and return the fiscal month as an integer
Posted on 2012-08-21
My fiscal year runs from October 1, 2012 to September 30, 2013. I've found functions that will return the fiscal week number with sufficient accuracy for my needs (I don't worry about the few days at the beginning or end of the year).
I would like a formula/function that will return the number of the fiscal month when I enter a particular date: for example: Oct 2, 2011 - 1; October 31, 2011 - 1, January 2, 2013 - 4, August 15, 2013 - 11, etc. I think this has been turned into a function in Access, but I need it for Excel. Any thought? Thanks, jn