SUM or work hours weekly

[MarkoFerjancic]

Hi!

I would like to set up excel to count how many hours a person has worked weekly. Do I need to set up every week manually or is there a function that does this automatically. I have different months on different sheets, so some weeks start on one sheet and continue on another.

Regards,

Marko

[BadlySpelledBuoy]

It's often not good practice to use a "month per sheet" layout as it usually causes more problems than it solves. Your issue here being a good example.
However it is possible. =SUMIF(1)+SUMIF(2) where the first is the calculation on the first month that a given week falls into and the second is the month it runs over into.

Post a sample workbook if you'd like a demonstration of what I mean.

BSB

[MarkoFerjancic]

I do know what you mean. Setting 2 SUMs is not a problem. But i have to pick the cells manually. Can excel automatically pick week days for me? If I change the dates on the top to november instead of october can excell recognize which cells are week days and which are weekend. The workbook is not in english I hope you will still be able to help.

Regards,

Marko

[BadlySpelledBuoy]

Could you advise which cells in the attachment you need these formulas in?

BSB

[MarkoFerjancic]

I've uploaded a new file. Columns AR to AV (week 1 to week 5).

Regards

Marko