Weekdays only

Premium

Deliveries only go out Monday to Friday. Write the custom validation rule for B2 in C2. With 2 as the second argument, WEEKDAY counts Monday as 1, so a weekday is less than 6.

C2
ABCDEF
1Order Delivery date Rule
25001 Nov 2, 2026
3
4
5
6
7
8

Premium lesson

Unlock Drop-down lists and data validation and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:COUNTIFSUMIF

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?