What formula can I use to subtract 90 days to dates in another column?

Olivia Moore

Example:

Column A has a bunch of different dates.

I want Column B to be each date minus 90 days

What would the formula look like? I know how to set it up for a specific cell =[Column A]1 - 90 but when I try to translate that to the whole column =[Column A]:[Column A] -90 or =([Column A]:[Column A]) -90 I get an error.

Thank you!!

Andrée Starå

Hi Olivia,

Try something like this.

=[Column A]@row - 90

Did that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help 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 Olivia,

Try something like this.

=[Column A]@row - 90

Did that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help 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!

Olivia Moore

Hi Andree,

Wouldn't that target a specific row? I don't really want to do that, I'd like to be able to copy and paste the exact same formula everywhere in Column B and pull the Column A- 90 days date.

Thank you!

Andrée Starå

Happy to help!

@row will look at the row the formula is on so it should work the way that you need it to.

Make sense?

Olivia Moore

Oh my god it worked! You are my hero thank you!

Andrée Starå

Excellent!

You're more than welcome!

✅Remember! Did my post help 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!