The DateValue function in VBA returns a VBA Date from the given String representation of a date wherein the time information is ignored. It is unable to interpret dates that include the text description of the weekday (Sunday, Monday, etc).

Syntax

Parameter

Date (required) – This parameter represents a valid String representation of date/time.

Return

This function returns a VBA Date from a supplied String representation of a date.

Example 1

Output

11/11/2020

VBA DateValue Function

Example 2

Output

VBA DateValue Function

Pin It on Pinterest

Share This