Forcing dates to be weekdays only


show more Forcing dates to be weekdays only provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Forcing dates to be weekdays only

One of Excel's great tools for controlling data in worksheet is data validation. In column C, we want to put in shipping dates, but there are two things we might be concerned with. We don't want any typos that in any way would suggest that the shipping dates before the order date. That wouldn't be so useful. Furthermore, maybe we're suggesting here that because this particular product that the company deals with, maybe it requires some assembling and packaging before shipping, it must be more than two days later than the order date. So, there is already a Data Validation rule in place here, and here it is.

If you're familiar with this feature, even though this looks a little strange, Formula, what it really is saying is any entry in column C must be more than two days later than the entry in column B. So, if for example here if we put in 9/4/10, this does not work, because it's got to be more than two days. So we'll change that and put in a 5. That will be acce...

Forcing dates to be weekdays only
Video duration: 3m 56s 3h 43m Intermediate

Viewers:

Forcing dates to be weekdays only provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...