Join Dennis Taylor for an in-depth discussion in this video Date limitations with basic controls, part of Excel 2013: Data Validation.
…In this worksheet called Date Time Control, we've…got a list of transactions in column A,…and order dates in column B, and shipping dates we're about to put into column C.…Copying these off a sheet of paper.…One of the advantages of data validation is it allows…us to catch not only bad entries, but typos as well.…And that's common when it comes to dates.…In column C, we want to make sure, first of all,…that all these shipping dates fall within the same year.…We could also, from a different perspective, say we…want to make sure that all these shipping dates occur…after the 13th of January because that's the first…order date that we have here in this sorted list.…
Or we might want to have just an ending date, we want to make…sure that all of our shipping is taken care of in 2014.…So, if we select column C as we often do in data validation,…because we want to make sure the entire…column is covered for the different entries.…We can then on the data tab, go to data validation.…And under settings, allow date.…And immediately we see the choice between.…
- Explain the difference between an error alert and an input message.
- Apply drop-down lists to save time and ensure consistency.
- Explore different ways to manage data with multitiered lists.
- Name the function that allows the placement of multiple restrictions within the same data validation.
- Review the steps necessary to create time limitations.