View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Assuming you want to sort them descending since they already are sorted
ascending,
copy them, then do editpaste special as values in place.

--

Regards,

Peo Sjoblom


"lizabright" wrote in message
...
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.