/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

3 votes174 views2 answers
Vba date to string
VBA
0 vote178 views1 answer
How to call gcd in vba
VBA
1 vote154 views1 answer
Excel date to unix timestamp
VBA
0 vote152 views1 answer
Programmatically copy data from one workshet to another excel
VBA
1 vote137 views1 answer
Excel vba hide zero values
VBA
3 votes145 views1 answer
Vba request json
VBA
0 vote141 views1 answer
Vb check if row has column
VBA
0 vote142 views1 answer
Vbscript abs
VBA
0 vote152 views1 answer
Vba vbcrlf chr
VBA
0 vote151 views1 answer
Vbnet round to nearnest thousand
VBA