The ISDATE function returns whether a value is a date.

Parts of an ISDATE function

ISDATE(value)

PartDescription
valueThe 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

AB
1Formula
2=ISDATE(“July 20 1969”)
3=ISDATE(“1969-20-07”)
4=ISDATE(“July”)
5=ISDATE(“Feb 30”)