Conditional validation not enforcing rules

Asked By 130 points N/A Posted on -

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?

Answered By 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)

Login/Register to Answer

Related Questions