View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Formula - assign a cell to show the next

Simply add 7: if 2/9/09 is in O10 then enter =O10+7 in P10!

Regards,
Stefi

€˛ash3154€¯ ezt Ć*rta:

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