The ISDATE function returns whether a value is a date.
Parts of an ISDATE function
ISDATE(value)
Part | Description |
---|---|
value | The value to be verified as a date. |
Sample formulas
ISDATE("7/20/1969") ISDATE(“July 20”) ISDATE(A1)
Notes
Ensure your date has quotation marks around it, unless it’s a reference to a cell.
Examples
A | B |
---|---|
1 | Formula |
2 | =ISDATE(“July 20 1969”) |
3 | =ISDATE(“1969-20-07”) |
4 | =ISDATE(“July”) |
5 | =ISDATE(“Feb 30”) |