That would be where you right-click on any date and select Group and show
detail, then Group. Should give you the option to group by days, weeks,
months, etc. And you can select your desired range of dates.

"ColleenK" wrote:

My preference would be to use a pivot table, but the dates come across as
every day. Is there a way in pivot tables to group the dates?
--
CK


"Sean Timmons" wrote:

I would think Pivot table may be better...

Drop the dates and your other desired field into the rows columns.
Right-click on a date, select outline and grouping, group. Pick weeks and
enjoy!

"ColleenK" wrote:

I have a list of items that occured on a daily basis since January-09, is
there any formula that will show what 2 week period the item falls in?--
CK