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



Keep in mind that this is formatted for the german locales.

%d bloggers like this: