/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

31 votes395 views1 answer
Excel vba function to convert column number to letter
VBA
1 vote294 views1 answer
Set font for ms chart vb.net
VBA
1 vote281 views1 answer
Excel vba autofit
VBA
0 vote263 views1 answer
Excel vba existence of a file
VBA
0 vote228 views1 answer
Vba code to remove leading and trailing spaces
VBA
2 votes232 views1 answer
Excel vba pause
VBA
0 vote279 views1 answer
Reset border color textbox vba
VBA
0 vote304 views1 answer
Remove last 8 characters from string vb
VBA
0 vote295 views1 answer
Excel vba disable screen update
VBA
0 vote278 views1 answer
Vb.net change cursor to wait
VBA