Counting percentage of month with multiple conditions

My attachment in Post #2 of this thread:

https://www.excelforum.com/excel-for...-segments.html

works out the number of days in each month for stays in hospital. Perhaps you can gain some insight from this and apply it to your own requirements.

Hope this helps.

Pete

Hi, to all!

You can try:
=MROUND(MAX(,MIN(EOMONTH(E$1,0),MAX($C2:$D2))-MAX(MIN($C2:$D2),E$1)+1)/30,0.25)

And drag it down and right. Blessings!

johnmpl: This works quite well and simplifies my original formula considerably, but do you have any suggestions on the formula if the end date (column D) is blank? This would represent employees who are still active and contributing.

Hi, again!

You can try then:
=MROUND(MAX(,MIN(EOMONTH(E$1,0),MAX($C2,IF($D2,$D2,TODAY())))-MAX(MIN(IF($C2,$C2,TODAY()),$D2),E$1)+1)/30,0.25)

Blessings!

Thank you! I threw in an IF statement and that did the trick.