View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default how do I have a cell that does the date plus 7?

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

"John W" <John wrote in message
...
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