Format cells with dates

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

 

[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)

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.

 

[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

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.

 

[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)

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.

 

[Peter Atherton]

-----Original Message-----
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.

.

Pat

If Mondays date is in A1 then in A2 type =A1+1 and copy
this formula.

Regards
Peter