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

[Waterhun]

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?

 

[Jeremy]

Try this:

=TODAY()+7

 

[RagDyeR]

=TODAY()+7
--

HTH,

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

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?

 

[Gord Dibben]

"in advance" to me means "before"

=TODAY()-7


Gord Dibben MS Excel MVP