Hey @AhmedSalih & @dpoggemann,
... this is my source column. As you suggested, i changed it to time zone independent. The wrong date didnt change in the "calculated" columns, but i deleted the wrong column and check out if this appears again. (because all other "Jubilee year columns" are working fine.
The strange thing here still is, that if i change the date in the source column manually, it always fills this cell with -1 day. E.g. if you type in "30.11.2022", it fills out the cell with "29.11.2022" (like in the picture above).
It's even more strange, that in the "calculated columns" it adds the years to the date i put in (30.11.2022) and not to the date it shows (29.11.2022). Check this screenshot:
(every second column is the date where i want to remind the company of the jubilee)
Do you know whats wrong here?
