How do I use week numbers for sub-totalling?
 

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.

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

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


In article ,
Tinpot wrote:

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.

Hi Tinpot

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



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Tinpot" wrote in message ...
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.