ISDATE Function

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.
Was this article helpful?
YesNo