Hi Everyone,
Is there a way to make a calendar date into 4 weeks? I tried using the formula I saw in the internet but it is showing 5 and 6 and sometimes no week 1 for the month.
Attached here is the template I'm working on.
Thank you in advance.
JLV
Last edited by Jarvin24; 05-24-2021 at 11:41 PM.
Questions:
1) Is the week from Mon to Fri?
2) Are you looking for week# within a month? 1 to 4 (or 5)
3) What if "1-Jan-2021" is Friday? Is it 1st week, then next Monday, 4-Jan-2021, is week 2 starting? then week 5 is 25-Jan-2021?
Could you input the manual outcome for Jan?
Quang PT
HI Sir Bebo,
Please see my comments below.
Questions:
1) Is the week from Mon to Fri? Yes sir, Monday to Friday only.
2) Are you looking for week# within a month? 1 to 4 (or 5) - 1 to 4 only
3) What if "1-Jan-2021" is Friday? Is it 1st week, then next Monday, 4-Jan-2021, is week 2 starting? then week 5 is 25-Jan-2021? - That's my dilemma, everything needs to restart to 1st week every month.
Could you input the manual outcome for Jan? - I'll manually put the outcome.
Sir Bebo,
Per supply chain. Sorry.. I need to start with Saturday and End with Friday... Apologies for the confusion
Last edited by Jarvin24; 05-24-2021 at 11:42 PM.
Do you mean start with Sunday and end with Saturday?Originally Posted by Jarvin24
The week start with Saturday and end with Friday... we have weekend delivery so it must be considered...
Cell E2=IF(WEEKDAY(B2,2)>5,"",WEEKNUM(B2,2)-IF(AND(WEEKNUM(B2,2)>1,WEEKDAY($B$2,2)<>1),1,0))
Hi Joseph,
Thank you... This formula counts the day per week but does not reset on a monthly basis... Each month, it must count week 1 to week 4 only and reset again next month.
What if the last day, 31/8, fell into Sat? 31/8 = week 4, and 24-30/8 = week 3, 1-10/8 = week 1 (10 days)
???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks