From the course: Excel 2016: Data Validation in Depth
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Date limitations using formulas
From the course: Excel 2016: Data Validation in Depth
Date limitations using formulas
- [Instructor] Sometimes when trying to set up data validation rules that require dates, you run into problems with the basic definition. As we look at this list here on the worksheet called DateFormulas, maybe all we're trying to set up initially is we want the shipping date to always be more than two days later than the order date, based on the fact that in our organization here based on the products that we handle, there's some assembly required, some packaging before these items can be shipped. So for example, that first entry here, this must be more than two days later so it's gotta at least the 14th of January or later. Now, if we select Column C and go Data Validation, then choose Date, we don't really have that capability there. We have the capability to set up dates between a starting date and an ending date. We can't quite use that there. And furthermore, we do want to make sure that all these dates are in 2016. So sometimes what we need to do, and even though we are about…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.