EasyRegex Logo
EasyRegex
Nuevo

Extract Year from Date in Excel

excel

Expresión Regular

\/(\d{4})\b
Copiar
¿Tienes Comentarios?

Explicación

This regex pattern captures and extracts the year part from a date in the format dd/mm/yyyy. It looks for a forward slash followed by exactly four digits (representing the year) and followed by a word boundary.

excel

Ejemplo de Uso

REGEXEXTRACT(A1, "\/(\d{4})\b")
Copiar
Prueba la expresión

Expresiones Regulares Similares