EasyRegex Logo
EasyRegex
Neu

Extract Year from Date in Excel

excel

Regulärer Ausdruck

\/(\d{4})\b
Kopieren
Haben Sie Feedback?

Erklärung

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

Beispielverwendung

REGEXEXTRACT(A1, "\/(\d{4})\b")
Kopieren
Testen Sie den Ausdruck

Ähnliche Reguläre Ausdrücke