FinanceTier 1210 minintermediate

Restrict a Payment Run Date to Weekdays Only

Add a custom validation rule so nobody can accidentally schedule a payment run on a Saturday or Sunday.

What you will learn

• Write a custom data validation formula using WEEKDAY
• Explain why checking "is this a valid date" says nothing about which day it falls on
• Choose the correct WEEKDAY numbering so weekends are excluded, not included

Excel skills

Data Validation - Custom Formula (WEEKDAY) · Data Validation

The task

Payment runs can only happen Monday to Friday. Add a custom validation rule to the Payment Run Date column so nobody can accidentally schedule a Saturday or Sunday run.

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