The service log needs a weekend filter. Add a helper next to the dates and test the two boundaries from Friday to Saturday and from Sunday to Monday.
Use the Monday-first WEEKDAY option
Put November 6 through 9, 2026, in A2:A5 as dates and leave A6 empty. In B2 enter this formula and fill it down:
=IF(A2="","",IF(WEEKDAY(A2,2)>5,"Weekend","Weekday"))The second argument sets Monday to 1. Friday is 5 and Saturday is 6, so the label first changes on Saturday.

Illustrated start boundary. A value over 5 is marked Weekend.
Check Sunday, Monday and the blank row
Sunday should be Weekend, Monday should be Weekday and B6 should stay empty. Filter the helper column for Weekend after the test. Check that imported dates are numbers formatted as dates, since text can be interpreted differently depending on locale. For a different workweek, write its actual days into the rule and run the corresponding boundary test.

Illustrated end boundary. Use actual dates in the imported column.



