Google Sheets
ISDATE function in Google Sheets
Returns whether a value is a date.
=ISDATE(value)ISDATE syntax and parameters
One argument, one required.
- valueanyRequired
ISDATE examples
Formulas you'll actually reuse.
Is the ship-date cell something Sheets can read as a date?
=ISDATE(D2)Result
TRUEHow many rows have an unusable date:
=SUMPRODUCT(--NOT(ISDATE(D2:D200)))Result
3
ISDATE in Excel
No direct equivalent — here's the way around.
Try ISDATE in the playground
Edit the example — nothing to install.
Preloaded with the ISDATE formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- CELLReturns the requested information about the specified cell.InfoExcel
- ERROR.TYPEReturns a number corresponding to the error value in a different cell.InfoExcel
- ISBLANKChecks whether the referenced cell is empty.InfoExcel
- ISEMAILChecks whether a value is a valid email address.InfoNo Excel equivalent
- ISERRChecks whether a value is an error other than `#N/A`.InfoExcel
- ISERRORChecks whether a value is an error.InfoExcel