=IF(A1<"",A1+7,"")

--
__________________________________
HTH

Bob

"J" wrote in message
...
Thanks that works.
Do youi know what formula I can put in other rows that will cause the
firls
to stay empty until I add the current date in row 1?

"Lars-Åke Aspelin" wrote:

On Fri, 1 Aug 2008 12:09:23 -0700, J
wrote:

Is it possible to have cell A1 with todays date and make B1 add 1 week
to
that date and display it?


Try the following formula in cell A1

=TODAY()

and the following formula in cell B1

=A1+7

Hope this helps / Lars-Åke