Ejemplo: excel vba convertir texto AAAAMMDD a la fecha
'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
¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)