/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 vote154 views1 answer
Vb run command
VBA
1 vote138 views1 answer
VBA Loop through recordset
VBA
3 votes157 views2 answers
Vba active workbook path
VBA
0 vote147 views1 answer
Vba full date format
VBA
7 votes165 views1 answer
Excerl vba array to range
VBA
1 vote137 views1 answer
Excel vba hide zero values
VBA
0 vote121 views1 answer
How to self delete a vbscript file
VBA
5 votes158 views1 answer
Excel vba right word from Long Integer
VBA
0 vote144 views1 answer
Vbnet line chart showing extra space
VBA
0 vote222 views1 answer
Application.ExecutablePath VB.NET
VBA