Counting percentage of month with multiple conditions

I'm attempting to calculate the percentage of a month that my employees contribute to each month based on their hire date and termination date and am running in to struggles. I've included a number of IF statements to do so, but am looking for guidance on the best practice for this. It seems that no matter what formula I use, I can only get a piece of the data needed and not all.

• Percentage of month employed based on hire date and termination date
• Increments of 25%

First time poster on any forum, so I apologize for any lacking in communication and am happy to answer clarifying questions.


Any guidance would be greatly appreciate!!