/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

8 votes182 views1 answer
Excel vba make integer
VBA
0 vote176 views1 answer
Tester si une case est vide vba
VBA
0 vote155 views1 answer
Do while not vb.net
VBA
0 vote171 views1 answer
Vba dictionary length
VBA
0 vote197 views1 answer
Set datetimepicker value to null vb
VBA
0 vote172 views1 answer
Vba check if class implements interface
VBA
0 vote161 views1 answer
Vba boolean to string
VBA
15 votes301 views2 answers
Xl vba dynamic string array
VBA
0 vote176 views2 answers
S yyyy-MM-dd em vb net
VBA
25 votes306 views2 answers
Excel vba folder exist
VBA