/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 vote217 views1 answer
Vba loop through table
VBA
0 vote216 views1 answer
Excel vba StartUpPosition
VBA
0 vote209 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote220 views1 answer
Vba get workbook name
VBA
0 vote156 views1 answer
Vba select file in folder
VBA
1 vote218 views1 answer
Excel vba close form escape key
VBA
0 vote213 views1 answer
Vba parameter adodb null value
VBA
0 vote241 views1 answer
Excel vba move down to next visible cell
VBA
7 votes234 views1 answer
Excerl vba array to range
VBA
5 votes240 views1 answer
Excel vba right word from Long Integer
VBA