IF With Dates not adding up

Hi,

I've attached a spreadsheet with a number of formulas.

What I'm trying to do, is divide the Amount (column I) by the length (column M), to get the Amount per week.

In columns P:AO I've added IF formulas to map the Amount to the right date. How ever, certain dates don't get add up.

Row is 300,000, 4 weeks, or 75,000 per week. But when I look at AB3 - it has no Amount associated, even though it's in between the right dates, and I can't figure out why it won't map.

Similar errors in the other rows..

Many Thanks,

eyeope