Date Data Validation

When working on a project timeline the end date should always be greater than the start date; however an error can occur when entering the dates manually into a spreadsheet. By using Date Data Validation you can ensure that the project end date is greater than the project start date as it notifies you should this not be the case.

Below is a demonstration of how this can be done. You can download the spread sheet to practice, click here.

Applies To: MS Excel 2003, 2007 and 2010

  1. Refer to the data given below

tip1 

2.  Select the range; C2:C8.

3.  From the Data tab, in the Data Tools group, select Data Validation

4.  Select as below;

tip2 

5. Select the OK button

6. Enter 2013/01/12 in cell C2.An error message given below will be displayed since 2013/01/12   is less than 2013/01/15

tip3 

Thus one is able to ensure that the data that users enter into a worksheet conforms to certain standards by enforcing the data validation rule