Formula needed to calculate number of days between 2 dates that equal a given value

[guivert01]

Hello.......Hoping someone can help. I have two date columns, a start date and end date. Another columns tells me the number of days between these two columns. It may return 45 days which actually straddle 3 different months.

My aim is to identify between this date range how many days in Apr 14. Then in the next column howmany days in May 14 etc

So on the spreadsheet Id have 12 columns for each month of the year. in Apr 14 for each row between the given date range I want it to tell me how many days are actually in April. Id then copy that formula into the May 14 column.


Hope this is clear??

Thanks in advance

[guivert01]

Okay so this works

=MAX(0,NETWORKDAYS(MAX($O2,Q$1),MIN($P2,EOMONTH(Q$1,0))))

But it is excluding saturday & sundays? Anyone know whay I replace NETWORKDAYS with? is there an ALL DAYS etc??