Calculation with dates ????

[Paul Sellis]

I'd like to calculate a date from another one.

I need to know which day is (for example) 335 days before the 13 March
2004.

How can I do that ?

Thanks.

 

[Jerry W. Lewis]

Put the date 13 March 2004 into a cell (say A1) and the formula =A1-335
in another cell.