Thread
:
how do I have a cell that does the date plus 7?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
PCLIVE
external usenet poster
Posts: 1,311
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
Reply With Quote
PCLIVE
View Public Profile
Find all posts by PCLIVE