ISDATE

Evaluates cells for date values.  If dates are found, TRUE is returned.   Cells with numbers or  text return FALSE.  Formatting cells with a date format does not transform cells with numbers into dates.

Syntax

ISBLANK(expression,{expression},...)

Arguments

expression Values or cell references to examine.

Example

ISDATE(A2) returns TRUE if cell A2 contains a validly formatted date.