5 Easy steps using Data Validation for dates in Excel

Training-Group-290x163When you are working on a project timeline in Microsoft® Excel®, the end date should always be greater than the start date; however, errors can occur when entering dates manually onto a spreadsheet. By applying Excel’s Date Data Validation you can ensure that the project end date will always be greater than the start date.

In this week’s tip we will show you how to apply the Date Data Validation feature in Excel, to help ensure that you have consistency in your data.

You are welcome to download the workbook to practice.

Applies To: Microsoft® Excel® 2010, 2013 and 2016.

  1. Select the range; C2:C8.
  2. From the Data tab, in the Data Tools group, select Data Validation.
  3. Select the Settings tab.

-Under allow, select Date.

-Under Data, select greater than.

-Under start date, enter =B2.

  1. Select the OK
  2. Enter 2013/01/12 in cell C2. An error message will be displayed since 2013/01/12 is less than 2013/01/15.