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(“20 July”)
ISDATE(A1)
Notes
Ensure that your date has quotation marks around it, unless it’s a reference to a cell.
Examples
| A | B | |
| 1 | Formula | Result |
| 2 | =ISDATE(“20 July 1969”) |
TRUE |
| 3 | =ISDATE(“1969-20-07”) |
TRUE |
| 4 | =ISDATE(“July”) |
FALSE |
| 5 | =ISDATE(“30 Feb”) |
FALSE |