Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I have a cell that does the date plus 7?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Empty Date Cell as Zero | Excel Discussion (Misc queries) | |||
if cell has date value how to calculate other cell values | Excel Discussion (Misc queries) | |||
insert date | Excel Worksheet Functions | |||
run a macro in a locked cell | Excel Discussion (Misc queries) | |||
HELP - Date Range In 1 Cell Calculation | Excel Worksheet Functions |