If a cell has a date in it formatted either mm/dd/yyyy or m/d/yyyy how can I
identify the year (yyyy) and copy the year only to a new cell?

Thanks!