VBA IsDate Function: The IsDate function in VBA returns a Boolean value indicating whether the given expression is interpreted as a VBA Date or not.

Syntax

Parameter

Expression (required) – This parameter represents the expression that you want to test for the Date.

Return

This function returns a Boolean value true if the specified expression is interpreted as a VBA Date else it returns False.

Example 1

Output

The IsDate will return TRUE
Excel VBA IsDate Function

Example 2

Output

The IsDate will return TRUE
Excel VBA IsDate Function

Example 3

Output

The IsDate will return FALSE
Excel VBA IsDate Function

Pin It on Pinterest

Share This