| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping dates into Fiscal Yrs/Qtrs/Months
I just learned how to group dates into years/quarters/months. How do I change
this to reflect a fiscal cycle (July - June)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Grouping dates into Fiscal Yrs/Qtrs/Months
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 "James" wrote in message ... I just learned how to group dates into years/quarters/months. How do I change this to reflect a fiscal cycle (July - June)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I get pivot table to order months by our fiscal year? | New Users to Excel | |||
| Calculating Dates Within Fiscal Year | Excel Discussion (Misc queries) | |||
| Formating Fiscal Quarters, rather than Months | Excel Discussion (Misc queries) | |||
| working with dates in fiscal years | Excel Worksheet Functions | |||
| Fiscal year total from running 12 months | Excel Worksheet Functions | |||
Linear Mode
