How to check valid Date value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I've a cell with Date format. How can I check if the cell contains a valid
Date value? E.g 8-14-2006 is valid, but "qwqwqwq" not
 
Click Data - validation and select date, then just use a date range
big enough.

Per Erik
 
You must log in or register to reply here.

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

Searching the formula (not the value) for a text string 1
validate date entered 3
countifs Function not giving desired result with date criteria 2
Data Validation for dates 5
Testing a cell value for a specific weekday. 3
need qualifier statement 10
custom data validation on cells with data validation values 2
Data Validation: Validate Specific Day of the Week? 2

Back
Top