/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 votes229 views1 answer
Xlvba double quotes in string literal
VBA
0 vote219 views1 answer
Vba collection contains
VBA
4 votes217 views2 answers
Vba create folder if not exist
VBA
0 vote204 views1 answer
Select case vba
VBA
0 vote213 views1 answer
Refer to resource using string variable vb.net
VBA
1 vote207 views1 answer
Excel vba saveas force overwrite
VBA
0 vote204 views1 answer
Vba add month to date
VBA
0 vote209 views1 answer
Vba run command
VBA
0 vote241 views1 answer
Vba code for cutoff time
VBA
0 vote205 views1 answer
Excel vba join variant array
VBA