Grouping dates into Fiscal Yrs/Qtrs/Months

J

James

I just learned how to group dates into years/quarters/months. How do I change
this to reflect a fiscal cycle (July - June)?
 
B

Bernie Deitrick

James,

You could use helper columns - with dates in column A, starting in A2:

For the fiscal year:
=YEAR(A2)-(MONTH(A2)<7)

For the quarter:
=INT(1+MOD(MONTH(A2)-7,12)/3)

For it all combined into one
="FY"&YEAR(A2)-(MONTH(A2)<7)&"-Q"&INT(1+MOD(MONTH(A2)-7,12)/3)

Then copy the formulas down to match your dates.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Tables and Fiscal Year 2
How do I convert a date to a fiscal year? 5
referencing cells based on conditions in other cells 1
filtering the pivot table..! 1
dynamic table 3
If statement 1
dynamic table 1
Change quarters in Pivot table when grouping 1

Top