Formula based filtering

[Rajus]

I have a to-do list with 20 different items with deadline dates listed for each item. These dates range from 2 days out to 6 months out, not necessarily listed in due date order. I would like a summary table which groups these items by due dates. I will group this items by Due in 1 week, Due in 2 weeks , Due in 1 month and disregard everything else.

Is this possible to do without using scripts? I am no good in doing scripts.

Thanks for your inputs.

 

[nbrcrunch]

Rajus. if you create another column and write a formula using the Weeknum() function, that should get you what you are after.