Dates, weeknumber functions

[Manos]

Dear all
i have a spreadsheet where in column a i have type of
electrical devices and form column B till column FG i have
the dates of six months.

So in an area from b5 to FG 650 i can see the deliveries
per day per electrical device

I want at the end of the days analysis to add a columns in
order to calculate the deliveries per week.

there is any formula or a great idea where i can make a to
calculate the weeks in order to see the deliveries per
week?

i.e. To check in the line 4 the days and in cell to see
week 1, in the cell after that the number 2 (week 2....)

Any good ideas?

Thanks in advance
Manos

 

[Frank Kabel]

Hi Manos
have a look at pivot tables for this (if I understood your layout
correctly). See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm