/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

1 vote151 views1 answer
Vba delete file
VBA
0 vote151 views1 answer
How to extract a file from an ISO:
VBA
3 votes152 views1 answer
Excel vba read registry key value
VBA
0 vote147 views1 answer
Vba add shape oval
VBA
0 vote140 views1 answer
Style percent not found vba
VBA
0 vote164 views1 answer
String contins in vba
VBA
0 vote147 views1 answer
Vba check 32 or 64 bit
VBA
0 vote160 views1 answer
Delete rows in excel vba code
VBA
0 vote182 views2 answers
Get unique random number in vb.net
VBA
0 vote158 views1 answer
Vba file chooser
VBA