View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default Formula - assign a cell to show the next

Hi,

In cell P10, try =P9+7

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ash3154" wrote in message
...
Basically, the Start of week can be any give day (ie Friday, or Sunday, or
Monday).
If the week starts on 2/9/09, than I would like to show next week will be
(2/16/09) in cell p10