/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 vote202 views1 answer
Winforms dark title bar
VBA
0 vote168 views1 answer
Ribbon show/hide
VBA
0 vote176 views1 answer
VBA
VBA
2 votes162 views1 answer
Excel vba check if key is in collection
VBA
0 vote163 views1 answer
Excel vba disable mouse click
VBA
5 votes110 views1 answer
Vlookup vba
VBA
8 votes175 views1 answer
Excel vba make a short integer from two bytes
VBA
1 vote158 views1 answer
Excel vba hide zero values
VBA
5 votes141 views1 answer
Vba array worksheet.index
VBA
0 vote174 views1 answer
Build an index all files of a FTP site
VBA