| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Define fiscal year
how to define fiscal year when it is not the calender year (Jan-Dec).
Example I need the fiscal year to be Oct-Sept. When I preapre a pivot table, I need the 1st quarter to be Oct-Dec in the group option |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Define fiscal year
Hi,
Hope this help, try to format the date as Oct-08, Nov-08 etc...Sept-09 and the pivot table will works. -- regards from Brazil Thanks in advance for your feedback. Marcelo "TeeLt" escreveu: how to define fiscal year when it is not the calender year (Jan-Dec). Example I need the fiscal year to be Oct-Sept. When I preapre a pivot table, I need the 1st quarter to be Oct-Dec in the group option |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Define fiscal year
I would add an extra column to the table where you calculate the fiscal
quarter (or fiscal month). Then summarize on that. Regards, Fred. "TeeLt" wrote in message ... how to define fiscal year when it is not the calender year (Jan-Dec). Example I need the fiscal year to be Oct-Sept. When I preapre a pivot table, I need the 1st quarter to be Oct-Dec in the group option |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Define fiscal year
Pivot Table, Group, Fiscal Year, Fiscal Quarter
Here is an implementation of Fred's idea: http://www.savefile.com/files/1671029 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help dealing with a fiscal year rather than a calendar year | Excel Worksheet Functions | |||
| Weeks left in a Fiscal year | Excel Discussion (Misc queries) | |||
| Birthdate as fiscal year | Excel Discussion (Misc queries) | |||
| Fiscal Year in date field | Excel Discussion (Misc queries) | |||
| Fiscal Year Calculation | Excel Worksheet Functions | |||
Linear Mode
