Hi Guys

I have a column (F) of amounts that vary between days of a month. I have another column (L) with order amount coming in after the amounts in column (F)coming in. In column (M) I want to show a multiplication of the two columns based on time scale. I will try to add my sheet to explain.
So if L12 an order comes in on 07/01/2012, Cell M12 will show amount based on amount in cell F10.
If L22 an order comes in on 17/01/2012, Cell M22 will show amount based on amount in cell F19 etc. Wondering if this is possible with formulas

PrintScreen.png