View Single Post
  #1   Report Post  
lizabright
 
Posts: n/a
Default Trying to create repeating dates and then sort column by date

Hi, I am trying to create a to-do list. I want to be able to put in tasks
and meetings that happen every week. At first I was putting a date 2/1/2005
(A24) + 7 and then dragging down. This worked great until I sorted by date
and then all the dates were screwed up.

I tried labeling the data, but then I can't drag down in a plus 7 format.
Is there any formula that will use a fixed date but keep adding in increments
of 7?

sorry this isn't a very coherent question.