function or formula to write the date minus 90 days?

[hawilder]

Hello -

I would like to have the entire year of 2011 in Col. A and minus 90 calendar days in column B... does anyone know if this is possible to do as a formula or something?

01/01/2011 - 90 days =
01/02/2011
01/02/2011
etc...

Thanks for your help

 

[UniMord]

You do exactly that. =A1 - 90 and copy down.

 

[Michael M]

Further to UniMords correct answer.....
Enter the formula in the first cell and double click on the bottom RH corner of the cell
( at the cross hairs)
It will then fill automatically, if the data in column A is consecutive.

 

[hawilder]

Thank you both!!!