CDate VBA Function – How to Convert Data to Date

1. CDate VBA Function – Description

The CDate VBA function   returns a value with the Date data type  . The Date data type is 8 bytes in memory. The function converts the date and time saved in text form to VBA formatted date and time. The function works like the VBA DateValue and VBA TimeValue functions when replacing text with a date . The difference is that CDate can return both date and time.

2. VBA CCur function – Syntax

CDate (Expression) As Date

Expression : Date and time saved as text e.g. 25-12-2018, 1 March 2018, 2018-05-19.

Function return : Date / Date and time

3. VBA CDate function – Example

How to use CDate function in VBA Excel? Below are examples of using the CDate function in the VisualBasic Editor.

Example 1 : Example of VBA CDate Function – result in the MsgBox window. Text on VBA date and time.

Dim strValue As String
strValue = "March 1, 2018 1:5:15 am"
Range ("A1") = CDate (strValue)

Example 2 : Example of VBA CDate Function – result in the MsgBox window. Convert text to date and time.

Dim strValue As String
strValue = "March 1, 2018 1:5:15 am"
Range ("A1") = CDate (strValue)
Excel VBA functions - CDate VBA function
Excel VBA functions – CDate VBA function

4. VB CDate function – Additional information

  • The function can take various time or date and time formats as an argument, e.g. “1: 5:15”, or # 12/28/2017 11:15:55 AM #, 25-12-2018, March 1, 2018, May 5, 2018 19.
  • Unlike the DateValue and TimeValue functions , it converts text to a date and time at the same time.

5. CDate VisualBasic function – Where to use?

The function can be used in: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016.

The article is part of the VBA Excel function list. You can find a list of all VBA functions at this address:  VBA functions .

Leave a comment

Your email address will not be published. Required fields are marked *

%d bloggers like this: