Formula for recognising dates between and outside a range of start and end times?

It is easy enough to say that if I started on the 10th of January, I was here for 22 days in the month and so should get 22/31 of the monthly salary, are you happy with this. If I worked a 6 month contract, the monthly figures may not add up to 6 calendar month

eg 10 feb to 9 aug
feb 19/28 of month
mar-July full month
august 9/31st of month

do you care?!


the below may work
=MAX((MIN($E9,EOMONTH(G$6,0))-MAX($D9,G$6))+1,0)/DAY(EOMONTH(G$6,0))*$F9/12

Thank you so much. That formula works perfectly and allows for pro rata days during a month only partly worked. Thanks!