How to backdate from another date?

Alex (Giant Pics Accts)

Is there a formula where I can backdate from a date. For example, if I have a column with dates and I create another column with the formula to calculate the backdate by 6 weeks, is that that possible?

Andrée Starå

Hi @Alex (Giant Pics Accts)

I hope you're well and safe!

Would something like this work.

=[Date Column]@row - 42

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Alex (Giant Pics Accts)

I hope you're well and safe!

Would something like this work.

=[Date Column]@row - 42

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Alex (Giant Pics Accts)

Thx! This worked.

Andrée Starå

@Alex (Giant Pics Accts)

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!