View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default In excel,how do I change the date to a date 84 days from previous

Of course Ron is right: it is PLUS 84

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
With the previous date in A1:

=A1-84


--
Kind regards,

Niek Otten

"Alister Edmond" <Alister wrote in
message ...
I would like to set up a spreadsheet, in order to monitor when someone is
due
a repeat order.The orders are due every 84 days I would be grateful for
any
advice.
I will be using excel 2003.