i will try to explain better
it is also based on a six day week (sundays excluded)

at the moment the code works like this
each part has its own cell

rate total
from date 12/12/07 to date 3/2/08 £20 835

what i need for it to do is :
rate total
from date 12/12/07 to date 31/12/07 £15 255

from date 01/01/08 to date 03/02/08 £20 580

total amount owed £835

hope this explains problem better

ronan

i will post code i am using in about an hour if need be