/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 vote176 views1 answer
Vba add spaces
VBA
20 votes338 views1 answer
Excel vba recursive example factorial function
VBA
1 vote159 views1 answer
How to do error handling in access vba
VBA
0 vote164 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote171 views1 answer
Visual basic msdos
VBA
3 votes169 views1 answer
Excel vba last row in range
VBA
0 vote186 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote182 views1 answer
Write listbox to text file vb.net
VBA
0 vote179 views1 answer
Vba range clear formatting
VBA
0 vote196 views1 answer
Vba is integer
VBA