"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?