Split periods between start and end dates and adjust a cost accordingly.

Hello,

I do not believe there is a solution for this so if anyone is a genius then let me know.

With the attached spread sheet, I am break down the start and end dates in order to get a budget cost per quarter for 2014. The quarter dates would be

01/01/14 - 31/03/2014
01/04/14 - 30/06/2014
01/07/14 - 30/09/2014
01/10/14 - 31/12/2014

The cost to split would only be the Total cost in Euros column.

Does anybody know if this is possible? Pleeeeeeeeeease help!

Many thanks in advance.