hiya guys and gals

I have a big problem. I need to make a spreadsheet for work. i'll try
to explain as best as i can.

Cells A6 to A64 contain the numbers 1 to 52, these represent the weeks
of the year. In cells B6 to B64 any hours that a staff member has been
off will be recorded. Cell C1 contains a member of staffs contracted
hours. Cell D1 contains the current week number. Cell E1 need to count
how many hours (from B6 to B64) were off, but only the last 26 weeks.
For example if the current week is 30 it would need to calculate from
wk 4 to wk 30 but if the current wk is week 5 it would need to add week
1 to wk 5 and wk 31 to wk 52.

I have tried loads of ways of doing this and just end up confusing
myself to the point of suicide!

I need HELP!!!!!!!!!!!!!!

Please to the sake of my blood pressure, help me find a solution!

Regards

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=503604