Calculation with dates ????

  • Thread starter Thread starter Paul Sellis
  • Start date Start date
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.
 
Put the date 13 March 2004 into a cell (say A1) and the formula =A1-335
in another cell.
 
Back
Top