How to Use ISDATE function in Google Sheets

ISDATE function:

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(“July 20”)
ISDATE(A1)ISDATE("7/20/1969")

Notes

Ensure your date has quotation marks around it unless it’s a reference to a cell.

Examples

A
B

1
Formula
Result

2
=ISDATE(“July 20 1969”)
TRUE

3
=ISDATE(“1969-20-07”)
TRUE

4
=ISDATE(“July”)
FALSE

5
=ISDATE(“Feb 30”)
FALSE