Data Validation Date Format

D

Dana M

,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?
 
N

N Harkawat

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
 
D

Dana M

Thank you very much, N. That worked nicely!

N Harkawat said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format 10
separating date and time 5
Data Validation, Custom 1
Data Validation 1
Data Validation, Custom 1
Cell Validation 2
How to enter a date in DD-MM-YYYY format 2
Change date format in Excel footer 2

Top