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

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