/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

3 votes246 views1 answer
Vba continue for each loop
VBA
2 votes216 views2 answers
Excel vba copy values range to another range
VBA
0 vote233 views1 answer
Openfiledialog specific folder
VBA
0 vote279 views1 answer
How to call gcd in vba
VBA
0 vote258 views2 answers
Get unique random number in vb.net
VBA
0 vote247 views1 answer
Excel vba set cell value to empty
VBA
1 vote177 views1 answer
Vba Remove Case Sensitivity
VBA
12 votes501 views1 answer
Excel vba write string to text file
VBA
1 vote216 views1 answer
Vba compile error object required
VBA
1 vote231 views1 answer
How to check is the value enterd is a number or text in vba
VBA