sharooonie said:
C Scull -
Did you ever figure out how to set the beginning of the fiscal year to a
time in the previous calendar year? I'm having the same problem but with
setting up quarters...
sharoonie,
Shouldn't be a problem. Using 2004 as the example, I set up the
timescale with 3 tiers although it will also work with 2 tiers. The
upper tier is "years" (2004, 2005, ...), the middle tier is "quarters"
(Qtr 1, Qtr 2, ...) and the bottom tier is "weeks" (W1, W2, from start).
The default setting for all tiers is for fiscal years.
Here's the most important step. Under Tools/Options/Calendar tab, make
sure the Week start on: is set for Sunday and the Fiscal year start in:
is set for January.
The fiscal year vertical line will start at the beginning of January,
but the first work week will start on 12/28/2004 (in this example).
Hope this helps.
John
Project MVP