View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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