Calculate Month of Quarter in Excel

Posted on 2011-10-21
Last Modified: 2012-08-13
I need to calculate the month of the quarter based on a date value and without using VBA/Macros.
Month       QTR  Qtr_Mo
1/1/11       1            1
5/1/11       2             2

Please see attached file.
Question by:tkyle
    LVL 50

    Accepted Solution

    Try this formula in B7


    format B7 as general and then copy formula across to M7

    regards, barry

    Author Closing Comment

    Works perfectly.
    LVL 50

    Expert Comment

    by:barry houdini
    ...of course you already have current month in B6 so you could make that simple bt replacing MONTH(B4) with B6, i.e.



    Author Comment

    The file that I am actually using only has the date.  Thanks.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    761 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

    7 Experts available now in Live!

    Get 1:1 Help Now