How do I insert a date that is always 7 days in advance of today
 

I use a spreadsheet that specifies a date 7 days in advance of today's, and
I keep forgetting to manually update this field. Can I insert a date that
will be 7 days in advance of tody's date to avoid me forgetting to insert it
manually?

How do I insert a date that is always 7 days in advance of today
 

Try this:

=TODAY()+7

"Waterhun" wrote:

I use a spreadsheet that specifies a date 7 days in advance of today's, and
I keep forgetting to manually update this field. Can I insert a date that
will be 7 days in advance of tody's date to avoid me forgetting to insert it
manually?

How do I insert a date that is always 7 days in advance of today
 

=TODAY()+7
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Waterhun" wrote in message
...
I use a spreadsheet that specifies a date 7 days in advance of today's, and
I keep forgetting to manually update this field. Can I insert a date that
will be 7 days in advance of tody's date to avoid me forgetting to insert it
manually?

How do I insert a date that is always 7 days in advance of today
 

"in advance" to me means "before"

=TODAY()-7


Gord Dibben MS Excel MVP

On Thu, 19 Jun 2008 09:05:00 -0700, Waterhun
wrote:

I use a spreadsheet that specifies a date 7 days in advance of today's, and
I keep forgetting to manually update this field. Can I insert a date that
will be 7 days in advance of tody's date to avoid me forgetting to insert it
manually?