EasyRegex Logo
EasyRegex
Nouveau

Extract Year from Date in Excel

excel

Expression Régulière

\/(\d{4})\b
Copier
Avez-vous des Retours ?

Explication

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

Exemple d'Utilisation

REGEXEXTRACT(A1, "\/(\d{4})\b")
Copier
Testez l'expression

Expressions Régulières Similaires