week number for financial year

  • Thread starter Thread starter peter
  • Start date Start date
P

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.
 
Hi :Peter,
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.
 
Back
Top