/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 vote127 views1 answer
Vb window.minimize
VBA
0 vote134 views1 answer
Excel R1C1 mode
VBA
0 vote139 views1 answer
Create links in msgbox in vb
VBA
3 votes141 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote145 views1 answer
VBA Sort RossetaCode
VBA
0 vote135 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote123 views1 answer
Vb net check if file exists
VBA
0 vote126 views1 answer
Vbnet check if sting contians symbols
VBA
5 votes143 views1 answer
Excel vba right word from Long Integer
VBA
0 vote136 views1 answer
Vba word open document read only
VBA