/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

5 votes208 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote189 views1 answer
Vba type
VBA
0 vote249 views1 answer
Excel vba delete columns in range
VBA
4 votes201 views1 answer
VBA Deep Clone Dictionary
VBA
1 vote176 views1 answer
Vba declare api 64 bit 32 bit
VBA
5 votes131 views1 answer
Vlookup vba
VBA
0 vote206 views1 answer
Vba search string position
VBA
0 vote177 views1 answer
Vba border weight
VBA
0 vote194 views1 answer
Vbnet chart make 0 gridline line different color
VBA
3 votes186 views1 answer
Vba not equal
VBA