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