I am not able to figure out how to just create a schedule for my different divisions for a weekend work rotation. I have the sheet for work schedules from here, but it is all month long for calendar days and I am not sure how to edit it to make it for weekends only. Can someone help?
Suggest you post a file that is representative (anonymized) of your actual file. Then mock up a possible solution (or explain specifically the expected results). It will make getting a valid response significantly easier.
Hello,
I am not sure if I picked the same Automated Work Schedule as you refer too, but it should work as a sample if not. I also assume you are using a newer version of Excel.
Formula to use to only get weekends (Saturday's and Sunday's). See sheet Work Schedule (2) in attached modified copy of Mynda's practice file.
=WORKDAY.INTL(B3-1;SEQUENCE(1;SUM(--(WEEKDAY(DATE(YEAR(B3);MONTH(B3);SEQUENCE(DAY(EOMONTH(B3;0));;DAY(B3)));2)>=6)));"1111100")
Can also recommend you to read Mynda's blog post about Excel WORKDAY.INTL Function.
Br,
Anders
I forgot to change the semicolon in the formula above to comma. If you check the formula in the attached file it will show up correct.
So, do not copy the formula in text as it will not work (unless you do have semicolon as separator).
Br,
Anders