Calculated date in column

%3CLINGO-SUB%20id%3D%22lingo-sub-2148047%22%20slang%3D%22en-US%22%3ECalculated%20date%20in%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2148047%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20someone%20please%20help%20me%20with%20a%20formula%20for%20a%20calculated%20column%20that%20displays%20a%20date%20of%20the%20weekday%20closest%20to%201%20year%20in%20the%20future%3F%20It%20needs%20to%20respect%20leap%20years.%20For%20instance%20%3CSTRONG%3E19%20Feb%202022%3C%2FSTRONG%3E%20is%20on%20a%20Saturday%2C%20so%20the%20formula%20for%201%20year%20from%2019%20Feb%202021%20needs%20to%20output%20either%2018%20Feb%202022%20or%2021%20Feb%202022.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20date%20needs%20to%20stay%20the%20same%20once%20it%20is%20output.%20How%20can%20I%20keep%20this%20date%20from%20being%20changed%20every%20time%20the%20file%20is%20updated%3F%20I%20want%20this%20date%20to%20stay%20the%20same%20until%20a%20Flow%20runs%20and%20changes%20the%20date%20to%20a%20new%20value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EAnne%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2148047%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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