|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 11th 09, 06:07 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Date Format
,I would like to use Data Validation so that users must enter a date in
MM/DD/YY format and the date entered must be after 1/1/2008. I've tried this: Settings - Allow: Date, Data: greater than or equal to, Start Date: 1/1/2008 I have an input message as well as a STOP Alert. However, it only works when some types of incorrect data are entered. If the user enters 01012009, it enters 10/13/70. Any ideas? 
|
| Ads |
|
#2
February 11th 09, 06:35 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Date Format
By entering 01012009 excel interprets it as 1012009th day after 01/01/1901
which is Oct-13-4670 As an alternative in data validation you could give between say start date: 01/01/2008" and End date: say 01/01/2011 or some such date "Dana M" wrote: > ,I would like to use Data Validation so that users must enter a date in > MM/DD/YY format and the date entered must be after 1/1/2008. I've tried this: > > Settings - Allow: Date, Data: greater than or equal to, Start Date: 1/1/2008 > > I have an input message as well as a STOP Alert. However, it only works > when some types of incorrect data are entered. If the user enters 01012009, > it enters 10/13/70. Any ideas?
|
|
#3
February 11th 09, 07:41 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Date Format
Thank you very much, N. That worked nicely!
"N Harkawat" wrote: > By entering 01012009 excel interprets it as 1012009th day after 01/01/1901 > which is Oct-13-4670 > > As an alternative in data validation you could give between say start date: > 01/01/2008" and End date: say 01/01/2011 or some such date > > > > "Dana M" wrote: > > > ,I would like to use Data Validation so that users must enter a date in > > MM/DD/YY format and the date entered must be after 1/1/2008. I've tried this: > > > > Settings - Allow: Date, Data: greater than or equal to, Start Date: 1/1/2008 > > > > I have an input message as well as a STOP Alert. However, it only works > > when some types of incorrect data are entered. If the user enters 01012009, > > it enters 10/13/70. Any ideas?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Format Cell and Data Validation | Maki | Excel Discussion (Misc queries) | 4 | September 1st 08 07:19 AM |
| DATE DATA VALIDATION | William | Excel Discussion (Misc queries) | 1 | August 8th 08 02:37 PM |
| Data Validation for a date | mgkaam | Excel Discussion (Misc queries) | 9 | January 25th 07 08:44 AM |
| Data Validation or Conditional Format (or combo of) | Scott | Excel Worksheet Functions | 3 | November 3rd 05 03:57 PM |
| Custom Format and Data Validation Q | John | Excel Worksheet Functions | 1 | January 6th 05 05:56 PM |
Linear Mode
