Calculated date in column

Contributor

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.

 

Thanks,

Anne

0 Replies