G
Guest
Is there a way to format cells so that dates would change when the lead date is changed. for example, when I input monday's date, tue, wed, thur, etc will follow suit.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Pat,
Assuming the first date is in A1
B1: =A1+1
C1: =B 1+1
etc.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
etc will follow suit.
Assuming the first date is in A1
B1: =A1+1
C1: =B 1+1
etc.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
date is changed. for example, when I input monday's date, tue, wed, thur,Pat said:Is there a way to format cells so that dates would change when the lead
etc will follow suit.
J
John Wilson
Pat,
Not sure if this is what you want, but if you put a date in cell A1,
you could use =A1+1 in cell A2. You could then drag the formula
down as far as you need to.
When you change the date in A1, all of the other cells where you
dragged the formula will follow suit.
John
etc will follow suit.
Not sure if this is what you want, but if you put a date in cell A1,
you could use =A1+1 in cell A2. You could then drag the formula
down as far as you need to.
When you change the date in A1, all of the other cells where you
dragged the formula will follow suit.
John
date is changed. for example, when I input monday's date, tue, wed, thur,Pat said:Is there a way to format cells so that dates would change when the lead
etc will follow suit.
G
Guest
Unbelievably easy! I figured so.
Thanks, Bob.
Pat
----- Bob Phillips wrote: -----
Pat,
Assuming the first date is in A1
B1: =A1+1
C1: =B 1+1
etc.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
etc will follow suit.
Thanks, Bob.
Pat
----- Bob Phillips wrote: -----
Pat,
Assuming the first date is in A1
B1: =A1+1
C1: =B 1+1
etc.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
date is changed. for example, when I input monday's date, tue, wed, thur,Pat said:Is there a way to format cells so that dates would change when the lead
etc will follow suit.
P
Peter Atherton
when the lead date is changed. for example, when I input-----Original Message-----
Is there a way to format cells so that dates would change
monday's date, tue, wed, thur, etc will follow suit.
Pat
If Mondays date is in A1 then in A2 type =A1+1 and copy
this formula.
Regards
Peter