» Validating Date Entries in Excel 2007
CATEGORY - Excel Editing
VERSION - Microsoft Excel 2007
1. Select a range of cells containing dates to validate.
2. Select Data -> Data Validation (in Data Tools Group) -> 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/2006.
6. In the End date box enter 12/31/2006.
7. Click OK.

Book Store:
Recommended Books:
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Business Plans Kit for Dummies (With CD-ROM)
- How to Pay Zero Taxes (Annual)
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Yes, You Can Time the Market!
No comments have been submitted.

