Excel - IsDate() function alternative

← PrevNext →

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.

24-01 2024

Here's the formula.



IsDate() function alternative in excel

← PreviousNext →