/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 vote214 views1 answer
Vba check 32 or 64 bit
VBA
0 vote215 views1 answer
Vba collection contains
VBA
0 vote144 views10 answers
Vba excel create event log
VBA
0 vote220 views1 answer
Excel vba Column Name from Column Number
VBA
8 votes262 views1 answer
Excel vba make word
VBA
0 vote266 views1 answer
Application.ExecutablePath VB.NET
VBA
5 votes228 views1 answer
Excel vba low word from Long Integer
VBA
4 votes216 views2 answers
Excel vba last column with data
VBA
3 votes214 views1 answer
Vba http request json
VBA
0 vote267 views1 answer
Vba vbcrlf chr
VBA