/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

4 votes183 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote179 views1 answer
Excel vba DisplayAlerts
VBA
0 vote174 views1 answer
VB Error Code BC30201
VBA
1 vote178 views2 answers
Get all column names from excel vba
VBA
2 votes168 views1 answer
Excel vba check if key is in collection
VBA
5 votes177 views1 answer
Excel vba get user selected range
VBA
1 vote171 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote155 views1 answer
Excel vba arrondir
VBA
0 vote188 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote157 views1 answer
Vba copy paste value only
VBA