Business Automation and Software Blog

Excel Tips and Tricks: Date Data Validation

Posted by Robert Baran on Fri, Jan 25, 2013 @ 11:53 AM

Excel Tips and Tricks / Business Reporting Question: I would like to ensure that the end date is greater than the start date? Can this be done in MS Excel?

Answer: Using Data Validation

Why: When entering project tasks the end date has to be greater than the start date

Applies To: Excel 2003, 2007, 2010

1. Refer to the data given below:

Excel Tips and Tricks

2. Select the range; C2:C8.

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

4. Select as below:

Excel Tips and Tricks

5. Select the OK button.

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

Excel Tips and Tricks

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. 

Contact PositiveVision ► ► for a Complimentary  Reporting Consultation

Topics: Business Reporting, Excel Tips and Tricks