how do I have a cell that does the date plus 7?

J

John W

I'm trying to work from the current date and have 24 other cells ad 7 days...
The problem is that at every 4 (yes in December 5) weeks the month also
needs to change. How can I do this?

I've tried stupid things such as =Date(+7) but no go. Then I got to
thinking about the month also...I need a formula to be automatic and update
on its own.

Thanks
John
 
P

PCLIVE

If it is from today, then:

=TODAY()+7

If the cell with the date in it is in a Date format, then your other cells
can just add 7.
Ex. Date in cell A1

B1 enter:
=A1+7

Should be that simple.

HTH,
Paul
 
B

Beege

John W said:
I'm trying to work from the current date and have 24 other cells ad 7
days...
The problem is that at every 4 (yes in December 5) weeks the month also
needs to change. How can I do this?

I've tried stupid things such as =Date(+7) but no go. Then I got to
thinking about the month also...I need a formula to be automatic and
update
on its own.

Thanks
John
Click to expand...

John,

If you use =TODAY()+7, you will have a dymanic (changing) sheet that updates
every time you open it. If you want it to be static, and have a date to
refer to, say in D1 you have 02/16/06,
than in your calculate cell it would be just =D1+7

Okay?

Beege
 
Top