Forum Discussion
annetoal
Feb 19, 2021Brass Contributor
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.
Thanks,
Anne
No RepliesBe the first to reply