Home |
Search |
Today's Posts |
#1
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? |
#2
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
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Cell and Data Validation | Excel Discussion (Misc queries) | |||
DATE DATA VALIDATION | Excel Discussion (Misc queries) | |||
Data Validation for a date | Excel Discussion (Misc queries) | |||
Data Validation or Conditional Format (or combo of) | Excel Worksheet Functions | |||
Custom Format and Data Validation Q | Excel Worksheet Functions |