/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

8 votes315 views1 answer
Vba make integer
VBA
0 vote223 views1 answer
Vba word pdf table to excel
VBA
0 vote261 views1 answer
Vba remove the first character of string
VBA
-1 vote265 views1 answer
Text to speech vb.net
VBA
5 votes242 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
1 vote244 views1 answer
How to remove zeros in excel
VBA
0 vote283 views1 answer
Vba code for cutoff time
VBA
0 vote238 views1 answer
Excel vba linter
VBA
5 votes262 views1 answer
Excel vba left word from Long Integer
VBA
0 vote273 views1 answer
Vb ternary
VBA