Evenly distrubute hours across date range by month and year

[hamish100]

I have a formula which will take hours and assign them evenly across a month based on a specified date range. The current formula does not have the ability to distribute hours across a date range evenly between two consective years . Current formula below and attached spreadsheet. Would appreciate some direction on correcting the formula.
=IF(AND(MONTH(D$2)>=MONTH($B3),MONTH(D$2)<=MONTH($C3)),IF(MONTH($B3)=MONTH($C3),$A3,IF(MONTH(D$2)=MONTH($B3),$A3*(NETWORKDAYS($B3,EOMONTH($B3,0))/NETWORKDAYS($B3,$C3)),IF(MONTH(D$2)=MONTH($C3),$A3*(NETWORKDAYS(EOMONTH($C3,-1)+1,$C3)/NETWORKDAYS($B3,$C3)),$A3*(NETWORKDAYS(EOMONTH(D$2,-1)+1,EOMONTH(D$2,0))/NETWORKDAYS($B3,$C3))))),"")

Formula will work as long as it stays within the same year
hours Start finish Nov-14 Dec-14
50 11/1/2014 12/29/2014 24.39 25.61

[samba_ravi]

give your result manually at least for 2 or 3 examples

[wenqq3]

D3=

Please Login or Register  to view this content.

E3 =

Please Login or Register  to view this content.

Assume your formula is working, just the if checking is not correct.
Compare month and year in the 1st IF function.

[hamish100]

Thank you. The formula works great.

[wenqq3]

Welcome.Thanks for feedback!