Google Exceltip.com
Account Icon
Shopping Cart
CheckOut

» Validating Date Entries

CATEGORY: Excel Editing
To validate date entries:

1. Select a range of cells with the date to validate.
2. From the Data menu, select Validation, and then select the Settings tab.
3. In the Allow dropdown list, select Date.
4. In the Data dropdown list, select between.
5. In the Start date box enter 1/1/2004.
6. In the End date box enter 12/31/2004.
7. Click OK.
Screenshot // Validating Date Entries

Validating Date Entries
Rate this tip
12 34 5
  RATING: 2.25
  VIEWS: 14680
  No comments have been submitted.


REGISTERED USERS click here to post comments


GUESTSclick here to Register
Name
Comment Title
Comments


Terms and Conditions of use
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation