Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In excel,how do I change the date to a date 84 days from previous
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
In excel,how do I change the date to a date 84 days from previous
On Thu, 9 Feb 2006 05:56:13 -0800, "Alister Edmond" <Alister
wrote: 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. Days are stored as serial numbers, with 1 = 1 Jan 1900 (or 2 Jan 1904 depending on date system being used) So to change the date by 84 days, merely add or subtract 84 from your date: e.g. Date in A1 =A1+84 Format as date. --ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
In excel,how do I change the date to a date 84 days from previous
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
cell color change based on due date | New Users to Excel | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
Roll back to previous date | Excel Worksheet Functions |