Date Sorting

[JayMan]

I have a worksheet that has multiple columns with dates in random order. I
need to sort the dates by descending order first count them and then group
them by period. For example
Task 1 Task 2 Task 3
1/5/2006 1/11/2006 1/5/2006
1/17/2006 1/12/2006 1/11/2006
1/26/2006 1/16/2006 2/6/2006
2/1/2006 1/16/2006 2/4/2005
2/22/2006 1/16/2006 2/4/2005
3/8/2006 1/16/2006 2/4/2005
3/13/2006 1/16/2006 2/17/2005
3/14/2006 1/18/2006 2/17/2005
3/14/2006 1/22/2006 2/18/2005
3/16/2006 1/22/2006 1/5/2006
3/16/2006 1/31/2006 1/16/2006
3/16/2006 2/6/2006 1/31/2006
3/16/2006 2/6/2006 2/6/2006
3/22/2006 2/6/2006 2/6/2006
3/23/2006 2/6/2006 3/11/2006
3/28/2006 2/6/2006 3/4/2005

I need something that looks like

Jan 1-15 Jan 15-31 Feb 1-15 Feb 15-28 Mar 1-15
Task 1 1 2 1 1 4
Task 2 2 8 5
Task 3 3 6 5 2


Any help on this is appreciated

 

[Roger Converse]

Hello,

Are you always going to have the same groupings (which appear to be
semi-monthly)? Also, is this something that is year specific or can it cross
years as well? In other words, would you start over every 1/1/YYYY or do you
want to see something like:

Jan 1-15 Jan 15-31 Feb 1-15 Feb 15-28 Mar 1-15........ Jan 1 - 15

Task 1 1 2 1 1 4 7
Task 2 2 8 5
Task 3 3 6 5 2

Thanks,
Roger

 

[JayMan]

Roger
the listing can cross years but your output looks good.