Extract Year from Date in Excel

Explanation

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.