A critical tool for controlling information before it gets into a worksheet is a…feature called Data Validation in Excel.…As we look at the data here in Column A, we are going to be putting in sales dates.…And let's imagine that in this particular worksheet that all the dates have…to fall within a certain range. Maybe it's for the year 2010, maybe it's for…the last half of the year, the first half or whatever. We can put controls to keep out bad data.…Column A, now many times if you are about to use Data Validation, it makes…sense, certainly not always, but makes sense here, to choose the entire columns,…just makes it simpler.…

The feature we are referring to is on the Data tab, and it's called Data Validation.…Now, in Column A, we want to make sure that these dates fall either within a…certain range, or they come after a certain date or before a certain date.…We have got some options here.…But on the Settings tab under Allow, click the arrow here, Date.…It automatically prompts us to use between.…

Resume Transcript Auto-Scroll

Author

Released

7/28/2010

In Excel 2010: Working with Dates and Times, Dennis Taylor shares his solutions for optimizing the use of dates and times in Excel 2010. This course explains what's going on behind the scenes when Excel stores dates and times, gives tips for entering dates and times, and shows options for date and time formatting. It also demonstrates the various date and time functions and shows how to calculate with dates and times in a range of scenarios. Exercise files are included with the course.