/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 vote193 views1 answer
Vba static variable
VBA
5 votes202 views1 answer
Vba low byte from INTEGER
VBA
-1 vote208 views1 answer
Code for reading letters only in vb 6
VBA
0 vote193 views1 answer
Excel vba combine ranges
VBA
0 vote209 views1 answer
Vbs run with cscript
VBA
0 vote180 views1 answer
Excel vba disable keyboard input
VBA
0 vote178 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote146 views1 answer
Vbide vbproject reference
VBA
1 vote198 views1 answer
Set font for ms chart vb.net
VBA
0 vote190 views1 answer
Excel vba join variant array
VBA