Excel VBA CDate Function

VBA CDate Function: The CDate function in VBA converts an expression into a Date (or Time) data type.

Syntax

CDate (Expression)

Parameter

Expression (required) - This parameter represents the expression that that you want to convert to a Date. It can hold both date and time information.

Return

This function returns an expression after converting it into Date. It returns the text representations of dates and times that are in a recognized Excel format.

Example 1

Sub CDateFunction_Example1()
 Dim date_val As Date
 date_val = CDate("12/01/2020")
 ' date_val will return the date 12/01/2020
 Cells(1, 1).Value = date_val
 End Sub 

Output

12/01/2020

Example 2

Sub CDateFunction_Example2()
 Dim date_val As Date
 date_val = CDate(43901)
 ' date_val will return the date 3/11/2020
 Cells(1, 1).Value = date_val
 End Sub 

Output

3/11/2020

Example 3

Sub CDateFunction_Example3()
 Dim date_val As Date
 date_val = CDate(4.6)
 ' date_val will return the date 1/4/1900
 Cells(1, 1).Value = date_val
 End Sub 

Output

1/4/1900