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.
Help Article Resources
Check out the Formula Handbook template!