View Single Post
  #3   Report Post  
Old November 27th 04, 02:55 AM
Mark
 
Posts: n/a
Default

Hi,
A bad way is to convert the formulas to theair absolute
serial number then reformat them back totheir date format

-----Original Message-----
I have a column of dates that I produced by putting in

the first date. Then
the next and following were simply a formula =SUM(A4+7)

and so on for five
years of Sundays. I wanted to have two for each sunday I

could have them
sorted by AM or PM so I duplicated the list and put AM in

the next column
beside the first 5 years of Sundays and PM beside the

next five years.
I then sorted with column A (dates) descending and column

B (AM/PM)
descending.
I expected to get 01/01/2000 AM and then 01/01/2000 PM

under each other and
so on but the formulated column would not sort. I tried a

sample of five
dates manually and they sorted fine but not when the

dates are produced by a
formula. I do not want to have to type in five years of

dates as that is the
reason we have formulas. How do I sort the formulated

column???????
.