Excel - IsDate() function alternative

Sharing a simple formula here in this post to check if value inside a cell is a date value. The formula is an altertive to IsDate() function in VBA. You can use this formula to check if a given value or a cell value (or text) is a date.

The formula to check date

Let us assume, I have a date column with some values like this (see below). I want to check if the values in the cell are date type.

05-02-2024
21-01-2024
24-01 2024
01-02-2024
12-01-2024

Here's the formula.

=ISNUMBER(DATEVALUE(TEXT(F9,"mm-dd-yyyy")))

Output

IsDate() function alternative in excel

← PreviousNext →