Date & Time: Invoice Due Date That Skips The Weekend

All versions

Net 30 on a Friday invoice lands on a Sunday, and collections teams do not want a due date nobody can pay. This recipe adds the terms to the invoice date, checks the weekday with WEEKDAY in Monday-first mode and uses CHOOSE to push Saturday by two days and Sunday by one.

Quick formula: Invoice date plus terms plus a weekend adjustment:

=B2+C2+CHOOSE(WEEKDAY(B2+C2,2),0,0,0,0,0,2,1)

An invoice dated Friday October 9 on net 30 would be due Sunday November 8, so the formula returns Monday November 9.

Functions used (tap for the full reference guide):

WEEKDAY CHOOSE

The example

Three invoices. The first lands on a Sunday, the third on a Saturday, and the second on a weekday that needs no change.

	A	B	C	D	E
1	Case	Invoice date	Terms (days)	Due date	Days shifted
2	Net 30 Friday	Fri 10/9/2026	30	Mon 11/9/2026	1
3	Net 15 Monday	Mon 10/12/2026	15	Tue 10/27/2026	0
4	Net 31 Wednesday	Wed 9/30/2026	31	Mon 11/2/2026	2

The formula

The raw due date plus a lookup of 0, 2 or 1 days depending on the weekday:

=B2+C2+CHOOSE(WEEKDAY(B2+C2,2),0,0,0,0,0,2,1) // due date; days shifted = Due - (Invoice + Terms)

How it works

Here is the logic, one piece at a time:

B2+C2 is the raw due date: invoice date plus terms in days.
WEEKDAY(B2+C2,2) returns 1 for Monday through 7 for Sunday.
CHOOSE(...) maps weekdays 1–5 to 0, Saturday (6) to 2 and Sunday (7) to 1.
Adding that adjustment to the raw date moves a weekend due date to the next Monday.

To skip holidays as well, use WORKDAY with a holiday list instead.

Try it: interactive demo

Interactive

Enter the invoice date and payment terms.

Invoice date (YYYY-MM-DD)

Terms in days

Variations

Skip holidays with WORKDAY

Move to the next business day after a holiday list.

=WORKDAY(B2+C2-1,1,Holidays)

Pull weekends back to Friday

Reverse the adjustment if your policy prefers the prior business day.

=B2+C2-CHOOSE(WEEKDAY(B2+C2,2),0,0,0,0,0,1,2)

Pitfalls & errors

WEEKDAY with the default return type numbers Sunday as 1; always pass 2 so Monday is 1 and the CHOOSE list lines up.

Payment terms measured in business days need WORKDAY, not simple addition.

Format the due date column as ddd m/d/yyyy so the weekday is visible.

Practice workbook

📊

Download the free Date & Time: Invoice Due Date That Skips The Weekend practice workbook

Edit the yellow invoice date and terms; the due date and days shifted recalculate.

Frequently asked questions

Why not just use WORKDAY?

WORKDAY counts business days; terms like net 30 mean calendar days, and this formula only adjusts the final date.

Can I add a grace period?

Yes: add the grace days to the terms cell.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Function references: WEEKDAY CHOOSE