Grouping and Graphs 1

[dbflora]

Is there some way to group date data by week ending. I need to convert daily information into info by week.

 

[PepeLeMokko]

If you are using a list, try using a pivot table.
When this is done you can group any items by selecting them, right clicking on the table and selecting "group".
( If they are dtaes you can group by weeks, months, years, whatever)
If there are items you don't wish to show, right click the table, choose " fields" and select the fields you want to hide.
Making a graph is easy: slect any item of the pivot table and push the "F11" button.
You will get the default graph which you can customize as you wish.

 

[klmorgan]

Use the WEEKNUM function on the date to identify the Weeknumber the date is in.

If the option of either a Sun or Mon start of week is not applicable then you can set the date with an offset ie date + 1 to get the weeknumber right (ours starts on a Saturday).

Then use the pvot table to sort.

If WEEKNUM does not appear in your list of functions go into Tools/Add ins and tick the analysis box

Regards

Keith

 

[dbflora]

Thanks!