defining a years length(start and end dates)

sorry dont know how to do that.i have zipped the whole program but can't paste it onto the forum for help

here is the zipped program

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.

cheers for any help

to zip the program i could only get it down to 121mb which is over the forum limit so had to copy the code into .txt file called mod function and macExceptional hope that this doesnt ruin the program

ronan