Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

Calculate Month of Quarter in Excel

Posted on 2011-10-21
Medium Priority
390 Views
I need to calculate the month of the quarter based on a date value and without using VBA/Macros.
Example:
Month       QTR  Qtr_Mo
1/1/11       1            1
5/1/11       2             2

MonthofQuarter.xlsx
0
Question by:tkyle
• 2
• 2

LVL 50

Accepted Solution

barry houdini earned 500 total points
ID: 37007009
Try this formula in B7

=MOD(MONTH(B4)-1,3)+1

format B7 as general and then copy formula across to M7

regards, barry
0

Author Closing Comment

ID: 37007019
Works perfectly.
0

LVL 50

Expert Comment

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

=MOD(B6-1,3)+1

barry
0

Author Comment

ID: 37007115
The file that I am actually using only has the date.  Thanks.
0

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Suggested Courses
Course of the Month10 days, 3 hours left to enroll