/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 vote354 views1 answer
Vb check if row has column
VBA
4 votes337 views1 answer
Excel formula for last non-empty cell in a column
VBA
1 vote350 views1 answer
Excel vba make cell visible
VBA
0 vote374 views1 answer
Vbnet check if sting contians symbols
VBA
6 votes400 views1 answer
Excel vba isalpha
VBA
0 vote349 views1 answer
Telephon call in vba
VBA
0 vote402 views1 answer
VBA
VBA
0 vote376 views1 answer
Excel VBA web scraping
VBA
0 vote345 views1 answer
Vba dictionary length
VBA
0 vote419 views1 answer
Vba search string position
VBA