View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
 
Posts: 318
Default group sales by week and week number

Hello I have a large spreadsheet over 10 thousand lines ... How do I
group the sales by weeks , and I also need the week number of the year.
example I want to group all the sales for Nov 7 2005 to Nov 13 then what
is the week number for Nov 7 2005 thru Nov 13 2005 thank you