Formulas to Group Data By Date

C

ColleenK

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
 
S

Sean Timmons

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!
 
C

ColleenK

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?
 
S

Sean Timmons

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.
 
Top