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.
|