From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Force typed dates to be weekdays only with data validation rules

Force typed dates to be weekdays only with data validation rules

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Force typed dates to be weekdays only with data validation rules

“

- [Voiceover] In this worksheet called Data Validation we want to make sure that the date entries in column K are more than two days after the order date. We also want to make sure that the shipping dates are not on a Saturday or a Sunday. This is a five-day week operation, we don't do shipping on those days. We need to know a few things ahead of time. There's a function called WEEKDAY. If you're looking at a date, that can only return the values 1 through 7, 1 is Sunday, 7 is Saturday, 2 is Monday, etcetera. That's a Thursday right there, a 5. So knowing that function or being familiar with it is going to be helpful. The other thing we need to make sure of is that the shipping date is more than two days after the order date, and we'll simply make a comparison between the two. Now, if you're not familiar with data validation, be sensitive to the idea that when you select the area where the validation rule is to go into place, for example, I'm clicking column K, or possibly I could be…

Contents