/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 vote314 views1 answer
Vba shape transparent
VBA
0 vote318 views1 answer
Freeze panes vba
VBA
0 vote323 views1 answer
Excel vba select multiple shapes
VBA
0 vote336 views1 answer
Add text to Shape VBA
VBA
0 vote345 views1 answer
Windows Forms dark title bar
VBA
0 vote298 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote315 views1 answer
Vba len variant
VBA
1 vote334 views1 answer
How to remove zeros in excel
VBA
3 votes316 views1 answer
Vba request json
VBA
0 vote330 views1 answer
Vbs exec hidden
VBA