How to use the CDate Function (VBA)

This Excel tutorial explains how to use the Excel CDate function with syntax and examples using VBA.

SUMMARY:

The Excel VBA CDate function converts an expression into a Date data type.

For example,

• The VBA Code CDate("12/30/2017") would return 12/30/2017
• The VBA Code CDate( "Feb 1 2018") would return 2/1/2018

PURPOSE:

To converts a value to a Date.

RETURN VALUE:

The CDate function returns a Date value.

REMARKS:

• The CDate function can only be used in VBA code in Microsoft Excel.
• The VBA Date data type holds both date and time information.
• The CDate function can interpret text representations of dates and times that are in a recognised Excel format.
• The CDate function is unable to interpret dates that include the text description of the weekday (Sunday, Monday, etc).
• If the year is not specified in the date, then the current year is used.
• The CDate function refers to your local settings when converting to dates.

CDate Function VBA Code example:

Diffrent way to use the CDate function using Excel VBA Code...

CDate Function Example (as VBA code)

The CDate function can only be used in VBA code in Microsoft Excel.
The following VBA code shows how the CDate function can convert values into Date data types.

Dim TestCase1 As String
Dim TestCase2 As Date
TestCase1 = "Mar 26, 2013"
TestCase2 = CDate(TestCase1)

In the above example, CDate(TestCase1) would return the date value 3/26/2013, the variable called TestCase2 would now contain the date value 3/26/2013

VBA CDate Function Error:

If the Expression that is supplied to the CDate function cannot be converted to a date or time, you will get the error:
Run-time error '13': Type mismatch

---

---

Download Example Sample Excel File

CDate-function-example.xlsm

Useful Links: Link 1… Link 2… Link 3… Link 4…