/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

4 votes237 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote221 views1 answer
Dynamically change drop down list visual basic
VBA
1 vote224 views1 answer
Excel vba first row in range
VBA
0 vote229 views1 answer
Internet explorer reference vba
VBA
0 vote247 views4 answers
How to continue formula in below line in vba code
VBA
0 vote234 views1 answer
Excel vba chrw max value
VBA
5 votes234 views1 answer
Excel vba right word from Long Integer
VBA
0 vote238 views1 answer
Excel vba formatconditions positive
VBA
0 vote238 views1 answer
Vbscript for loop
VBA
0 vote256 views1 answer
Vbnet revrese the order of character in string
VBA