week number for financial year

[peter]

Using the "cpearson" formula
=TRUNC(((I8-DATE(YEAR(I8),1,0))+6)/7)
to display the week works with the calendar year. What if
I want to start "Week 1" on 10/1/03, hence 9/25/04 to
9/30/04 will be "Week 53" and that's the last week of the
year. Then, 10/1/04 becomes "Week 1" again. How can I
change the formula? Thanks for your input.

 

[peter]

Thank you.

 

[David McRitchie]

Hi eter,
Since Harlan was the only one I see that replied you might thank
him by name. Please don't change the subject as most of
us have in our view only the unread postings so can't tell immediately
what you are thanking someone for.