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