Apportion costs using dates

Hi all,

I have a spreadsheet that contains a list of costs which are apportioned to a time period but what i'd like to do is spread those costs equally depending on how days there are in the period for each cost... hopefully the attached workbook will help understand what i'm looking for...

I was thinking of a SUMIF but think this could end up being very complicated and lengthy?

Any help would be much appreciated.

Thanks in advance

ColinExample.xlsx

Thanks shg,

I've tried to implement days and network days forumla but can't seem to get it to work.....

See attached.