Quarter Calcuation

S

sur

Board Regular
Joined
Jul 4, 2011
Messages
176
Hi Team,


need to calculate the Quarter for the Fiscal year starting October to September.


Please help
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Sort by date Sort by votes
And ....
where might we start?

I'm not into finance but what are you asking? How to evaluate one specific Quarter, a Quarter in general?
What is involved?
 
Upvote 0
A variety of alternatives.


Excel 2010
ABCDE
11-Sep-17412
2443
3474
44101
5
3cc
Cell Formulas
RangeFormula
B1=INT((MOD(MONTH(A1)+(12-10),12))/3)+1
B2=LOOKUP(MONTH(A1),D1:E4)
B3=LOOKUP(MONTH(A1),{1,2;4,3;7,4;10,1})
B4=CHOOSE(MONTH(A1),2,2,2,3,3,3,4,4,4,1,1,1)
Named Ranges
NameRefers ToCells
Int='2a'!$B$4
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
Calculate quarterly paid interest for days base deposit
Replies
8
Views
185
Dave Patton
D
M
  • Question
COUNTIFS formula for number of dates in a quarter??
Replies
4
Views
202
Alex Blakenburg
A
J
  • Question
Financial Impact by Quarter weighted by the month?
Replies
0
Views
315
johncon60
J
CubeMonkey
  • Question
Week Number based on Day. (Based on United States Government Fiscal Year)
Replies
1
Views
517
MDCurry
M
S
  • Question
Building customer cohort chart with dynamic renewal rates and periods
Replies
3
Views
131
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,215,310
Messages
6,124,187
Members
449,147
Latest member
sweetkt327

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top