How to check valid Date value?
 

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

How to check valid Date value?
 

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

Per Erik

On Mon, 14 Aug 2006 04:09:01 -0700, hstijnen
wrote:

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