Calculated date in column


Could someone please help me with a formula for a calculated column that displays a date of the weekday closest to 1 year in the future? It needs to respect leap years. For instance 19 Feb 2022 is on a Saturday, so the formula for 1 year from 19 Feb 2021 needs to output either 18 Feb 2022 or 21 Feb 2022.


The date needs to stay the same once it is output. How can I keep this date from being changed every time the file is updated? I want this date to stay the same until a Flow runs and changes the date to a new value.




0 Replies