Grouping sales data into weekly buckets

J

John S.

I have sales data that I want to analyze in weekly buckets. I can group all sales in a month by using the MONTH formula. (MONTH(actual invoice date)). I was wondering if anyone knows of a way or has a suggestion for grouping sales by week. Some type of formula that has an output stating the week of the actual invoice date. Any suggestions?
 
N

Norman Harker

Hi John!

You'll really need to introduce a week numbering formula and then
you'll be able to group into weeks more easily.

Take a look at the WEEKNUM function in the Analysis ToolPak Addin.

But note that there are other methods than the two that Excel allows:

Chip Pearson:
http://www.cpearson.com/excel/weeknum.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top