/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

1 vote345 views1 answer
Sort using vba
VBA
0 vote338 views1 answer
Vba get text file content
VBA
0 vote332 views1 answer
Excel vba populate array with cell values
VBA
0 vote368 views1 answer
Excel vba clear filter
VBA
1 vote377 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote351 views1 answer
Vba type
VBA
0 vote346 views1 answer
Reset border color textbox vba
VBA
0 vote339 views1 answer
Vbscript abs
VBA
0 vote331 views1 answer
Excel vba existence of a file
VBA
5 votes415 views1 answer
Excel vba last byte from INTEGER
VBA