excel date seperate

[wheefus]

hi all
i have a problem with a piece of code

here is my problem

i have a date calculator which is linked to pay
at the moment it works when a payment period is for example 12/12/07 to 3/2/08
and the related pay is
up to 31/12/07 is £15 a day and from 1/1/08 is £20 a day
it gives out the right total amount showing on one output line 12/12/07 to 3/2/08 = £ xxxxx
but i need the sum to show the total as two seperate year totals eg the amount from 12/12/07 to 31/12/07 on one line then
1/1/08 to 3/2/08 on another line

many thanks for any help
ronan

[Cheeky Charlie]

(31/12/07 - 31/12/07) * 15 = x
(03/02/08 - 01/01/08) * 20 = y

Can you turn your explanation into a question? I'm not really sure what you're asking for...

CC

[wheefus]

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

[wheefus]

thanks charlie

look here this is what i mean

http://www.digioz.com/forum/viewtopic.php?f=15&t=620

[Cheeky Charlie]

That's enormous, it's clear to you what you're asking because you are dealing with it, but for an outsider like me, that's a huge amount of VBA to scroll through. Help us to help you by uploading examples which make the question you're asking clear.

I suggest you go to whoever wrote the macro in the first place if you're out of your depth; or I'll fix it for a fee - it's too big for spare time!

CC

[wheefus]

Thanks charlie

i have been thinking about it and i will just use a cheat method on
the print off page to give out the right answer e.g.
If column a2 says a certain date do this ,if that date do that i
think this will get around my date issue instead of getting it working 100% correctly through vba