Grouping sales data into weekly buckets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top