Dates, weeknumber functions

M

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
 
Top