/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 vote348 views2 answers
Get unique random number in vb.net
VBA
0 vote336 views1 answer
Excel vba Column Name to Column Number
VBA
1 vote339 views1 answer
Excel vba last column in range
VBA
1 vote336 views1 answer
Excel vba force recalculation
VBA
0 vote335 views1 answer
Vba get relative cell address
VBA
4 votes332 views2 answers
Excel vba last column with data
VBA
0 vote354 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote318 views1 answer
Excel vba extract year
VBA
-1 vote355 views1 answer
VBA check if a cell contains a letter or string
VBA
1 vote314 views1 answer
Vbscript convert ascii code to character
VBA