Help creating a complex formula

I have a spreadsheet that has a list of applicable dates in one column. (Say Column A, and there's a few years worth of dates.)
I have cell with a start date.
I have a cell with an end date.
I have a cell that calculates an accrual rate for holiday accrual.
I need a formula to put into Column B that will do the following. (Assume Cell B1)
Check to see if the date in Cell A1 falls between Start Date and End Date, and if so, show the accrual for that day. If not, show 0 instead.

In addition to this, a person could hold more than one position which means they could accrue holidays at a different rate. Example: they could hold a position for 50% of the time that accrues holiday time at %5.5, (because this position is 50% time, it would actually accrue at 2.75%) and hold a position for 25% of the time that accrues holday time at %11.54.(because this position is 25% time, it would actually accrue at 2.885%)  And these different positions could have different start and end dates. So, if a person was employed with both positions during a day, their accrual should be 5.635% for that day.

There would be a seperate column for each position, and a seperate start/end date for each position, so after the formula, I would add all applicable accruals together to show proper accruals for a payperiod.

I know it's weird having each day listed, but I couldn't think of a way to eliminate weekends. (Holiday's don't accrue on weekends) so I've listed every day in Column A, and not included weekends. ~sighs~

So, hopefully this is clear. Ask any questions you need.

:o)

Bartender_1