View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith
 
Posts: n/a
Default how do I combine monthly dates ex: jan 1,2005+jan 1,2006 together.

What do you mean by "mess Jan/Dec 2006 members into one list"? Merge them?

With regards to sorting, the easiest way to sort by day of month is to create an
extra column with =day(a1) in it, then sort on that column.

--
Regards,
Fred


"Marion" wrote in message
...
Have 2500 members registered in Jan/Dec 2005 need to mess Jan/Dec 2006
members into one list? They need to be in day (1,2,3,etc) sequence not year
sequence (Jan-2005 then Jan-2006- which is what I am getting..... help, please