Summary of Prevent Invalid Dates With Excel Data Validation

00:00:00 - 00:05:00

This video explains how to use data validation in Excel to control what dates are entered into cells. By using the year function and the equals sign, it is possible to ensure that dates entered into the worksheet are within the current year.

• 00:00:00 This video explains how to use data validation in Excel to control what dates are entered into cells. First, a workbook is set up for people to enter data. Next, data validation is used to control what dates are entered. The date list is then created and used to populate a drop-down list on the other sheet.
• 00:05:00 This video demonstrates how to prevent invalid dates from being entered into an Excel worksheet using data validation. By using the year function and the equals sign, it is possible to ensure that dates entered into the worksheet are within the current year.