» Validating Date Entries in Excel 2007
CATEGORY - Excel Editing
VERSION - Microsoft Excel 2007
To validate date entries: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:
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Analysis of Financial Statements
- Marketing Plans That Work, Targeting Growth and Profitability
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
No comments have been submitted.
