/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 vote237 views1 answer
Set font for ms chart vb.net
VBA
0 vote225 views1 answer
Find days in month vba
VBA
0 vote242 views1 answer
Method showalldata of object _worksheet failed vba
VBA
3 votes225 views1 answer
Excel vba change format of cell
VBA
0 vote232 views1 answer
Vba first line of string
VBA
0 vote212 views1 answer
Excel vba milliseconds
VBA
1 vote208 views1 answer
Vba listindex select multiple items vba
VBA
18 votes397 views3 answers
Excel-vba make integer
VBA
5 votes251 views1 answer
Excel vba get user selected range
VBA
1 vote215 views1 answer
Excel vba hide zero values
VBA