The german version of Excel uses the german translated function names (someone said ugly?). Now the challenge is
– add a date into a cell (excel auto-detects this to be a date)
– get only the year value into a new cell
Steps needed
– convert B4 date to string
– get the date value of that string
– get the year of that integer
=JAHR(DATWERT(TEXT(B4; "TT.MM.JJJJ")))
Voilà!
Keep in mind that this is formatted for the german locales.