View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Twishlist Twishlist is offline
external usenet poster
 
Posts: 54
Default How to create a sequential weekly date list, each separated by 5 r

I want to create a running sheet of dates down the page, each date is 7 days
ahead of the former. Also, each date will be separated by 5 rows before the
next date isdisplayed.
I can find date formulas that calculate number of days inbetween given
dates, but can't find a simple 'add 7 to the last date' function. It's
probably simple, but I would welcome some guidance.