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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tie a Calendar week to a Scoped Projected Week 3
Nesting if/or/and 4
Modifying a complex date formual to count months 4
match 3
General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY 3
Please help me -urgent 1
week numbers 3
Sort by Year and Week 1

Back
Top