Putting number of days in proper month

[gasguzzler]

I am trying to break apart the approved amounts into the proper months. I am not sure if I need to add extra columns for months after columns D&E or if there is logic to do.

Ulitmately I would like to run this across multiple columns for items over 200 days and put the information into the proper months.

Row 3 for example per the attached would be broken into the number of days for Aug'90, Sep'09, Oct'09....Aug'10.

Kinda fo new to writing logic information. I appreciate any help in regards to this. If columns need to be added or changes made please see the attached item and let me know.

Sincerely appreciate the help!

[daddylonglegs]

If you list the 1st of each month across row 1 starting at D1 (with at least one more month than the latest you need then you can use this formula in D2 copied across and down as necessary

=$C2*MAX(0,MIN(E$1,$B2+1)-MAX(D$1,$A2))/($B2-$A2+1)

Tried to attach an example but I can't at the moment - I'll try again later

[gasguzzler]

That works like a charm thank you so much. I never would have been able to do that. I greatly appreciate your help and quick response on this