Administration and Executive AssistantTier 1210 minintermediate

Restrict a Date to Weekdays Only

Use WEEKDAY inside a custom validation rule to reject weekend dates.

What you will learn

• Write a custom data validation formula using WEEKDAY
• Explain why validating "is this a date" is not the same as validating which day it falls on
• Choose the correct WEEKDAY return-type argument for a Monday-start week

Excel skills

Data Validation - Custom Formula · Data Validation

The task

This collection service only runs Monday to Friday. Add a custom validation rule to the Collection Date column so nobody can accidentally book a Saturday or Sunday collection.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free