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
true
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.

Search
Clear search
Close search
Google apps
Main menu
14744444787790243538
true
Search Help Center
true
true
true