View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sundance Sundance is offline
external usenet poster
 
Posts: 3
Default How create a continuous date range: 9/14-9/20/09, 9/21-9/27/09

I would like to be able to type in a cell a date range such as a week: for
example: 9/14 - 9/20/09, and in the next cell type the next date range, being
the following week: for example: 9/21 - 9/27/09. Then highlight both cells
and have Excel calculate the rest of the continuous weekly date ranges for
the rest of the year. Is this possible in Excel?