Conditional validation not enforcing rules

Asked By Marco P Hamm 130 points N/A Posted on - 12/26/2014

Why does the conditional validation rule fail to restrict the rule set? I need to compare the current cell against the value returned by a function. I use this formula to prevent a person using the workbook from entering a date that falls on a weekend:” = (WEEKDAY(C4)<>2, WEEKDAY(C4)<>7)”. If C4 is the cell that containthe validation rule, What prevents the formula from forcing C4 to adhere to both restrictions?

• Status: Open
• Question Views: 537
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Anyet Thngo 0 points N/A #193481

Conditional validation not enforcing rules

Hi Marco,

 

The purpose of the formula is to ensure that the user cannot input dates that fall on a Saturday or Sunday. This is exactly what the WEEKDAY function does and the weekday number is the output. "AND" should be included as shown below for the validation rule to restrict the input dates to weekdays.

 

=AND (WEEKDAY (C4) <> 1, WEEKDAY (C4) <> 7)

 

 

Regards,

Anyet

About Anyet Thngo

Questions
3

Answers
81

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 02/02/2015
• Question Category: MS Excel