Lesson: 26 | Close Date Must be Weekday

Validation Rule

Field	Value
Rule Name	CloseDateMustBeWeekDay
Formula:	`OR(WEEKDAY( CloseDate ) =1, WEEKDAY( CloseDate ) =7)`
Error Message:	Select a weekday.

Field	Value
Rule Name	CloseDateMustBeWeekDay
Formula:	`OR( MOD(CloseDate - DATE(1900,1,7),7)=0, MOD(CloseDate - DATE(1900,1,7),7)=6)`
Error Message:	Select a weekday.

You need to login to have access to the quizzes. START QUIZ

Mastered by 40 users.