/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 clear collection
VBA
0 vote198 views1 answer
Vba border weight
VBA
-1 vote204 views2 answers
How close excel through visual basic
VBA
0 vote225 views1 answer
Sendkeys vba selenium
VBA
0 vote199 views1 answer
Vba parameter adodb null value
VBA
0 vote197 views1 answer
Afficher un message d'erreur vba
VBA
0 vote190 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote220 views1 answer
Freeze panes vba
VBA
0 vote191 views1 answer
Vbnet get file name from path
VBA
0 vote225 views1 answer
VBA
VBA