EasyRegex Logo
EasyRegex
Nuovo

Extract Year from Date in Excel

excel

Espressione Regolare

\/(\d{4})\b
Copia

Spiegazione

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

Esempio di Utilizzo

REGEXEXTRACT(A1, "\/(\d{4})\b")
Copia
Prova l'espressione

Espressioni Regolari Simili