Checks whether a value is a date.
Sample Usage
IF(ISDATE([Due Date]1), "Cell contains a date", "Cell doesn’t contain a date")
Syntax
ISDATE(
-
value
-
value—The value, typically within a cell, to check.
Usage Notes
- This function is typically used inside of another function, for example: IF, COUNTIF, or SUMIF.