If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel VBA: Function to Obtain Correct Date Format When Converting Text to Date

Thread starter Akuini
Start date Mar 5, 2024

Overview Discussion

Akuini

Well-known Member

Mar 5, 2024

Akuini submitted a new Excel article:

Excel VBA: Function to Obtain Correct Date Format When Converting Text to Date - How to get date format as expected when converting text to date

Dealing with dates in VBA can be a bit tricky. When attempting to convert a string to a date, we may encounter unexpected results. The issues typically arise in the following ways:
- The day, month, and year might get swapped or changed unintentionally.
- What we typically consider as an incorrect date format may actually be considered valid by VBA.

My Windows date setting uses d-m-y format, so all examples below generate results base on that setting.

Example 1:
Using CDate, the day &...