Calculate Financial Quarter from a date

Posted on 2011-10-19
Last Modified: 2012-05-12
I want to know if there is a simpler way to calculate the Financial Quarter

Sorry to add another question on this topic but I failed to find a simple answer which would work for any date (happy to be redirected).  I don't want to write out a special table manually but to work it out mathematically.  
The quarter "1" is Jul - Sep, "2" is Oct - Dec, etc

The following returns what I want, but idealy I would not use the IF() statement, and only reference the date cell once if possible.

The simplest/shortest solution using vba or excel formula.

Question by:_Benaiah
    LVL 50

    Accepted Solution

    Hello _Benaiah

    Try using LOOKUP, it can be adjusted depending on where your quarters start


    ...or this will give the same result


    regards, barry
    LVL 43

    Assisted Solution

    by:Saqib Husain, Syed
    LVL 43

    Expert Comment

    by:Saqib Husain, Syed
    Hi Barry, I did not expect you at this time.
    LVL 1

    Author Closing Comment

    Barry's formula slightly more suited to my purposes but thanks both of you
    LVL 50

    Expert Comment

    by:barry houdini
    >I did not expect you at this time
    Hehe....nor did I!

    One more for fun?


    regards, barry
    LVL 43

    Expert Comment

    by:Saqib Husain, Syed

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    746 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

    16 Experts available now in Live!

    Get 1:1 Help Now