Notification

Passkeys are the simplest and most secure way to sign in to your account. To sign in with just your fingerprint, face scan, or screen lock, create a passkey.

ISDATE function

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	Result
2	`=ISDATE(“July 20 1969”)`	TRUE
3	`=ISDATE(“1969-20-07”)`	TRUE
4	`=ISDATE(“July”)`	FALSE
5	`=ISDATE(“Feb 30”)`	FALSE

Need more help?

Try these next steps:

Post to the help community Get answers from community members

Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search

Close search

Google apps

Main menu