/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

0 vote356 views1 answer
Excel vba disable screen update
VBA
0 vote326 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote333 views1 answer
Telephon call in vba
VBA
3 votes334 views1 answer
Excel vba change format of cell
VBA
0 vote335 views1 answer
Vbscript check if string contains
VBA
0 vote331 views1 answer
Vb check if row has column
VBA
4 votes346 views1 answer
Vba create directory
VBA
0 vote351 views1 answer
Send text to clipboard vb.net
VBA
6 votes382 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote327 views1 answer
Vba sheet visible
VBA