View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default Figure future date

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