View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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?