How To Prohibit Weekends Using Data Validation

Monday, June 23rd, 2014

Written by Jane Hames

How to prohibit weekends using Data Validation

The standard Data Validation offers some really useful options such as controlling the dates, text and numbers that can be entered in to cells. A few times recently, I have been asked how to set up data validation so that it only allows weekdays to be entered and sees weekends as invalid.

Read more on How To Prohibit Weekends Using Data Validation…