View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana M Dana M is offline
external usenet poster
 
Posts: 27
Default 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?