/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 vote227 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
0 vote222 views1 answer
Filesystemobject vba reference
VBA
0 vote210 views1 answer
Date as number vb
VBA
0 vote227 views1 answer
Excel vba DisplayAlerts
VBA
0 vote197 views1 answer
Vba add month to date
VBA
0 vote159 views1 answer
Vbide vbproject reference
VBA
0 vote227 views1 answer
Vba extract filename from path
VBA
0 vote205 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote211 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote202 views1 answer
Test if form is open vb
VBA