excel date entry manipulation

[wheefus]

hi all
i am in the process of updating a calculator to determine the amount owed in a given period. in which for the last 3 days of 2008 29/12/-31/12 are subject to a different rate of pay. at the moment all the dates in 2008 are been rated at 197.80. when the dates are entered in a from and to cells in excel. the rate for the 29/12/08 to 31/12/08 is 204.30. my question is : is here a formula i can use that if the dates 29/12/to 31/12 are entered the rate 204.30 will override the 197.80 value that shows up.
was thinking of an if statement like this { =IF(A2=39811,"204.30","197.80") but to include the 3 days not just the one day

many thanks

ronan
if you like you can email me directly at [email protected]

[martindwilson]

=IF(A2>=39811,"204.30","197.80")
or=IF(and(A2>=39811,a2<=39813),"204.30","197.80")

[wheefus]

thanks martin

[Steve R]

I did a workbook that sums different rates, depending on date criteria. Maybe someone thinks it is useful. (Yellow cells are input cells)

[wheefus]

thanks for your excel file
it seems to be appropriate for what i need