/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 vote119 views1 answer
Vbscript remove spaces from string
VBA
3 votes112 views1 answer
Excel vba make long from two shorts
VBA
0 vote137 views1 answer
Thread sleep vb
VBA
5 votes98 views1 answer
Vba array worksheet.index
VBA
3 votes125 views1 answer
Vba make long from two shorts
VBA
0 vote124 views1 answer
Excel vba hide gridlines
VBA
1 vote118 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote182 views1 answer
Find the name of the last excel sheet vb
VBA
3 votes114 views1 answer
Vba not equal
VBA
0 vote128 views1 answer
Vba is integer
VBA