|
» Validating Date Entries
CATEGORY: Excel Editing |
VERSIONS: 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. |
| Screenshot // Validating Date Entries |
  |
|
RATING:
2.25
VIEWS: 14680 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- The New Financial Order: Risk in the Twenty-First Century
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
Related MS EXCEL TIPS:
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.
