/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 vote172 views1 answer
Docker vboxmanage not found
VBA
0 vote167 views1 answer
Vbnet make a string to unicode converter
VBA
3 votes190 views1 answer
Excel vba change format of cell
VBA
0 vote207 views1 answer
VBA Sort RossetaCode
VBA
0 vote234 views1 answer
Excel vba protect content
VBA
0 vote185 views1 answer
Excel vba chrw max value
VBA
0 vote190 views1 answer
Vbnet check if sting contians symbols
VBA
1 vote179 views1 answer
Vba delete array element
VBA
0 vote198 views1 answer
Excel vba open browser
VBA
0 vote197 views1 answer
Excel vba Column Name to Column Number
VBA