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
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)
Last edited by mehmetcik; 11-08-2018 at 07:19 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
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.
Please advise. Thanks so much
How about
=WEEKNUM(EDATE(K4,-4),12)
YES! Thank you Fluff13!
Glad to help & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks