Google Sheets workday formula builder

Pick your weekend days and point it at your date cells and holiday list to get a due-date or workday-count formula you can fill down.

Weekend days

Formula

What does the seven-digit weekend string mean?

Each digit is one day, Monday first, and a 1 marks a day off. "0000011" is a Saturday and Sunday weekend, and "0000110" is Friday and Saturday. Google also accepts a number code for the common patterns, but the string reads the same for any combination, so the builder always writes the string and shows the number beside it when one exists.

Does the count include the start date?

The due-date formula never counts the start date, so a start on Friday plus 1 workday lands on Monday. The count formula includes both ends when they are workdays, so it returns one more than the workdays you added whenever the start date is itself a workday.

How was this builder checked?

Tests confirm the builder produces the exact formulas published in the guide, maps every weekend pattern to the number codes in Google's documentation, and rejects malformed cells and ranges. The formulas were evaluated on sample dates in HyperFormula, an independent spreadsheet engine, not in Google Sheets, so compare the first few rows with a calendar. For the full setup with a holiday sheet, see Count workdays and set due dates in Google Sheets with holidays.

Esc