/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

2 votes285 views1 answer
Excel vba pause
VBA
0 vote325 views1 answer
Get current url vb.net
VBA
0 vote360 views1 answer
Excel vba add reference programmatically
VBA
0 vote351 views1 answer
Remove last 8 characters from string vb
VBA
1 vote330 views1 answer
Add control vb
VBA
1 vote322 views1 answer
Vba compile error object required
VBA
4 votes401 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote355 views1 answer
Vba registry settings
VBA
-1 vote347 views1 answer
Vba code to add new column in table
VBA
0 vote335 views1 answer
Vba leading zeros in string
VBA