Here's my Spreadsheet:

1/1/2008 2/1/2008 3/1/2008 4/1/2008
1/15/2008 2/15/2008 3/15/2008 4/15/2008
1/31/2008 2/29/2008 3/31/2008 4/30/2008
Column - C G H I J K L
Month Start Date End Date January February March April
5,821.83 1/1/08 4/15/08

Trying to write combinations of If(And statements whereby salary (column C)
for a person will start at their start date and continue across all months
until there is an end date, if there is one at all. I have tried so many
iterations, breaking the formula up in to pieces to see which part doesn't
work etc. and I just keep getting stuck. I need to calculate for 1/2 month
intervals if their start or end date is in the middle of the month. Thank
you.