Formulas to Group Data By Date

  • Thread starter Thread starter ColleenK
  • Start date Start 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
 
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!
 
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!
 
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?
 
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?
 
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.
 
Thank you so much, it did not dawn on me to use groups in Pivot tables
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find criteria based data and display next to a count in another wk 2
Count If formula with week range 9
Pivot Table Dates 1
Add data from other sheet to the data present in this sheet 1
Calculate days in a given month between two dates 6
Reference Formula Help 1
Total to date formula 3
date formula issues?!?! 1

Back
Top