Days In Each Month In Date Range

Hi,

I have a start date (purple) in one cell& end date (blue) in another, off to the right there is a column with a EOM date heading (orange). In the cells highlighted in green for each row I need a formula that counts the days between the start date & end date for for that speceific row.

I have attached a sample spreadsheet & populated the numbers that would expect to see in row 2. For example there is 30 days (H2) between that start (E2) & end date (F2) that fall between EOM (G$1) & EOM (H$1).

Your assistance would be greatly appreciated.

Thanks

Branno

first i would like to say thank you for the workbook and very clear question

second, try this:

=IF(AND($E2<=G$1,$F2>EOMONTH(G$1,-1)),IF($F2>G$1,G$1,$F2)-IF($E2<=EOMONTH(G$1,-1),EOMONTH(G$1,-1)+1,$E2)+1,0)

Not really understanding how you arrive at the values you do. For instance, in Col K, how do you get 3? and in Col H, how do you get 30?

Maybe if you could explain those 2 examples here such that...datexxx and dateyyy used because of ???
so therefore datexxx +/- dateyyy = 30