Roll a due date that lands on a weekend forward to the next business day with WEEKDAY
WEEKDAY turns any date into a plain number for the day of the week it falls on, and a number is something IF can test and arithmetic can act on — which is what turns "if it's a weekend, push it" into one formula instead of a separate rule for Saturday and another for Sunday.
Task:
You process accounts-receivable invoices for a regional utility company. Your bank's ACH system doesn't process payments on Saturdays or Sundays, so any invoice due on a weekend has to be pushed out to the following Monday before it's sent — a due date that already falls on a weekday is left exactly where it is. In column C, work out each invoice's adjusted due date: if the due date in column B is a Saturday, add two days; if it's a Sunday, add one day; otherwise leave it unchanged. Fill in rows 2 through 6.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Invoice | Due Date | Adjusted Due Date |
| 2 | INV-4401 | 10/10/2026 | |
| 3 | INV-4402 | 10/13/2026 | |
| 4 | INV-4403 | 10/11/2026 | |
| 5 | INV-4404 | 10/17/2026 | |
| 6 | INV-4405 | 10/20/2026 |
What this exercise teachesMay contain the answer
WEEKDAY(B2) returns 7 for October 10, 2026, the Saturday INV-4401 is due on, so the outer IF catches it and adds two days, landing on Monday, October 12. October 11, the Sunday INV-4403 is due on, returns 1, so the inner IF adds just the one day it needs to reach that same Monday. October 13, a Tuesday, returns 3 — a match for neither test — so the formula falls through to its last argument and adds nothing, leaving INV-4402 exactly where it was. Writing the rollover as a number of days added to the original date, rather than searching for "the next Monday" directly, is what lets one formula handle a Saturday due date and a Sunday due date with two different corrections instead of needing a formula apiece.