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.

With Monday-first numbering, Friday is 5 and Saturday is 6.

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.

Sunday is 7, Monday restarts at 1 and a blank date stays blank.

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

Microsoft’s WEEKDAY return types