How to check valid Date value?

H

hstijnen

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
 
P

Per Erik Midtrød

Click Data - validation and select date, then just use a date range
big enough.

Per Erik
 
Top