» Validating Date Entries
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- Microsoft Windows XP Step by Step (With CD-ROM)
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Microsoft Windows XP Inside Out
- Microsoft Access Version 2002 Step by Step
- Good to Great: Why Some Companies Make the Leap... and Others Don't
No comments have been submitted.
