Altering Week Number of the Year Sequence

1. Altering Week Number of the Year Sequence

Hi,

I'm using the formula =WEEKNUM(K4,2) to count weeks of the year based on a specific date. However, our fiscal year does not run January to December, it runs May 1 - Apr 30. How would I change the above formula to reflect this? Or do I use a different formula all together?

TIA

2. Re: Altering Week Number of the Year Sequence

You should modify the formula to modify the month in K4 by 4 months.

=WEEKNUM(DAY(EOMONTH(\$K\$4,0))+DAY(EOMONTH(\$K\$4,1))+DAY(EOMONTH(\$K\$4,2))+DAY(EOMONTH(\$K\$4,3)),2)

3. Re: Altering Week Number of the Year Sequence

Thanks for the info mehmetcik, however, when I use that formula, the right week number does not come up.
Example: Date is 09/19/2018, using =WEEKNUM(K4,1) the formula answer is 38. Using your formula, the answer is 19. However, by physically counting the date 09/19/2018 using May 1 as week 1 of the fiscal year, the count is actually week 21.

4. Re: Altering Week Number of the Year Sequence

=WEEKNUM(EDATE(K4,-4),12)

5. Re: Altering Week Number of the Year Sequence

YES! Thank you Fluff13!

6. Re: Altering Week Number of the Year Sequence

Glad to help & thanks for the feedback

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1