Enter date and return the fiscal month as an integer

Posted on 2012-08-21
Last Modified: 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
Question by:jknichlsn
    LVL 24

    Accepted Solution

    if the date is in A2:


    Does that suffice or does it need the date portion too?

    Author Closing Comment

    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!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Suggested Solutions

    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now