Formula to Allocate Cost every week according to the number of days in a week

Hello All,
I am using Excel 2010 and have attached a sample of my problem
I wish to have a formula in the yellow colored cells in my sample attached.

The formula should check the number of days in a week and allot per day cost accordingly.
I have done S.No. manually for explanation purpose.

Thanks in advance for any help

Rashid Khan

So a new week starts on a Friday? E.g. from Friday to Thursday?

If you would calculate it by weeknumber (Mon-Sun), this would work:

G5: =SUMPRODUCT(--(WEEKNUM($C$5-1+ROW(INDIRECT("1:"&$E5)))=WEEKNUM(G$3))*$F5)

and copy across.

Cheers,
berlan

Dear Berlan
Yes
Week starts from Fri to Thursday
Your formula gives zero for the first value eg G5

Sorry bebo for the late reply.
My laptop had some issues..
Your formula works.
But I did not get an answer from Berlan
Thanks