Forum Discussion
Formula 4 week rotation excluding Fridays and weekends
Hi. I'm creating an employee work calendar. I need to formulas. One i have it but the other one i cannot figure it out. Employee A works from home, called W, one day a week. Week 1 on a monday, week ...
I hope below solution will resolve you issue for 4 weeks rotation...
Week Number Formula
=INT((DAY(B1)-1)/7)+1
Weekday Number (Mon=1)
=WEEKDAY(B1,2)
Employee A WFH
=IF(AND(B3<6,CHOOSE(B2,1,2,3,4,1)=B3),"W","")
Employee B WFH
=IF(AND(B3<6,CHOOSE(B2,2,3,4,1,2)=B3),"W","")
If this resolves your query don't forget Mark as Solution.