Calculation with dates ????

P

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.
 
J

Jerry W. Lewis

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