Setting date limitation formulas


show more Setting date limitation formulas provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010: Data Validation in Depth show less
please wait ...

Setting date limitation formulas

In this worksheet, data validation rules in columns C require that all the dates occur in the year 2011. Column D doesn't have any rules yet, but in putting in the shipping dates for the items that have been ordered, we are going to make sure, first of all, that the shipping date is later than the order date. Now depending upon the environment of course, you might want to set up a rule to make sure that the shipping date is equal to or greater than the order date. But what if in this environment that the items being ordered require some assembly and packaging, and shipping cannot occur within a two-day time frame? In other words, it has to be more than two days later.

We want to make sure that the entries in column D are more than two days later. In this case, maybe we don't want to restrict these to the year 2011 because toward the end of the year some of the items might be shipped in the later year. So clicking column D here and setting up data validation, the first thought mig...

Setting date limitation formulas
Video duration: 7m 2s 59m 45s Intermediate

Viewers:

Setting date limitation formulas provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010: Data Validation in Depth

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