Forcing typed dates to be weekdays only with data validation rules

- In this workbook, we're looking…at a worksheet called "Data Validation."…In the worksheet, "Data Validation,"…in columns "F," "G," and "H," we've got a list set up,…and multiple people will be using this,…it might grow, might grow throughout the year.…Need to put in shipping dates here.…None of the shipping dates can be Saturday or Sunday.…We don't do shipping on those days.…Shipping date also has to be after the order date.…So, we want to make sure that these…are not those weekend days.…You may or may not know of a function called "Weekday()".…

So here's a date, maybe it's March 4th, 2015.…The weekday function, I'll write it right underneath.…If it's referring to that cell,…will return a value between one and seven.…One is Sunday, two is Monday, etcetera, seven is Saturday.…So that's a Wednesday.…So.…What we want to make sure, is,…that none of the shipping dates,…none of the entries that are going to go in to column "H,"…are going to equal to be one, or equal to seven.…So we're gonna set up a data validation formula here.…