<div>
Super fast response. &nbsp;Someday, I'd like to add an error message if the date entered is outside the fiscal year that the starting cell lies in, but for now, just dandy. &nbsp;Thank you!
</div>


Super fast response.  Someday, I'd like to add an error message if the date entered is outside the fiscal year that the starting cell lies in, but for now, just dandy.  Thank you!

<div>
<div class="content wysiwyg-content">
My fiscal year runs from October 1, 2012 to September 30, 2013. &nbsp;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).<br />
<br />
I would like a formula/function that will return the number of the fiscal month when I enter a particular date: &nbsp;for example: Oct 2, 2011 - 1; October 31, 2011 - 1, January 2, 2013 - 4, August 15, 2013 - 11, etc. &nbsp;I think this has been turned into a function in Access, but I need it for Excel. &nbsp;Any thought? &nbsp;Thanks, jn
</div>
</div>


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

Enter date and return the fiscal month as an integer

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.