How do I use week numbers for sub-totalling?

[Guest]

I can obviously set-up week numbers manually on the spreadsheet, but was
wondering if there was a function I could use that could work straight from
the date field.

 

[JE McGimpsey]

Try a Pivot Table. That will allow you to group by week, month, quarter,
etc..

http://www.contextures.com/xlPivot07.html

 

[Ron de Bruin]

Hi Tinpot

With this Add-in you can filter on Week numbers straight from the date field.
http://www.rondebruin.nl/easyfilter.htm