visual basic editor- defining length of a year

[wheefus]

hi
i am updating a work calculator. i am stuck. the problem is the new rates
for 2008 came into effect from 31-dec-2007, so i have to have the rates for
2007 to stop on 30-12-07.and 2008 to kick in when the 31-dec-07 is entered.i
am doing this through the excel macro visual basic editor.

any help on this code is appriciated


problem1---- when date 24/12/07-6/1/08 the calculation(personal-full
calculate) comes out correct i.e.
6 days at rate 185.80 and 6 days at 197.30. showing the end of 2007 is
20/12/07 and the start of 2008 is 31/12/07.
but if you enter just 24/12/07- 31/12/07 the result show a calulation of 7
days at 185.80 instead of 6 days at 185.0 and 1 day at 197.80.

problem 2 ----- tax is calulated if the number of days is over 36. but since
the tax year ends on the 31/12/07 (unlike the 30/12/07 whe the new pay rates
start) the way i have the calculator now will calculate the end of the tax
year as 31/12/07 if the date ends on the 31/12/07 but wont calculate 31/12/07
as the last date of 2007 if 2008 dates are included too.

i could email you the zipped program if needed as code is very long to put
up here i think

my email is (e-mail address removed)

cheers for any help

ronan