revenue sheet based on the daily calculation ( attached sample )

Dear Sirs ,

Required your support to make revenue sheet based on the daily calculation ( attached sample )

You said daily calculation but columns are listed for end of month dates.
Can you enter some results [manually] and explain how you want these results calculated?

(Sorry about my English)

Please try.

E4
=IF(OR(DATE(YEAR($B4),MONTH($B4)+1,1)-1>E$3,DATE(YEAR($C4),MONTH($C4)+1,1)-1<E$3),0,IF(DATE(YEAR($B4),MONTH($B4)+1,1)-1=E$3,E$3-$B4+1,IF(DATE(YEAR($C4),MONTH($C4)+1,1)-1=E$3,DAY($C4),DAY(E$3))))*($D4/($C4-$B4+1))

Regards.