excel vba convert text YYYYMMDD to date

The solution for “excel vba convert text YYYYMMDD to date” can be found here. The following code will assist you in solving the problem.

‘In Excel we sometimes need to work with imported dates that
‘are of the form: YYYYMMDD, for example: 20200325.

‘Excel needs numbers (not text) for plotting charts and calculations.

‘VBA function to convert text in YYYYMMDD format to real Excel dates:

Function Text2ExcelDate(t$)
Text2ExcelDate = DateSerial(Mid(t, 1, 4), Mid(t, 5, 2), Mid(t, 7, 2))
End Function

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts