/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 vote302 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote318 views1 answer
Vba remove the first character of string
VBA
1 vote288 views1 answer
Vba delete file
VBA
0 vote280 views1 answer
Refresh token em vb net
VBA
1 vote322 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote305 views1 answer
Excel vba combine ranges
VBA
0 vote286 views1 answer
Vbnet line chart showing extra space
VBA
0 vote299 views1 answer
Excel vba calculate
VBA
0 vote309 views1 answer
Excel named range sum
VBA
0 vote291 views1 answer
Refer to resource using string variable vb.net
VBA