/VBA/Excel vba convert text YYYYMMDD to date

Excel vba convert text YYYYMMDD to date

'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

Similar codes

5 votes357 views1 answer
Excel-vba get integer high byte
VBA
0 vote309 views1 answer
String contins in vba
VBA
0 vote308 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote323 views1 answer
Excel vba clear filter
VBA
5 votes881 views1 answer
Vlookup vba
VBA
0 vote324 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
13 votes441 views2 answers
Vba write text file
VBA
0 vote319 views1 answer
Send text to clipboard vb.net
VBA
0 vote287 views1 answer
Excel vba existence of a file
VBA
31 votes447 views1 answer
Vba how to convert a column number into an Excel column
VBA