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



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!!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!