Spread cost over time automatically using multiple activity start and finishes

Hi Guys,

I am currently trying to put a sheet together that will automatically spread cost over time using multiple date sets. I have the formula working for one set of dates however some items need to be spread across more than one activity i.e. up to 4 sets of dates and i was wondering if there was a way to do this? An example of the spreadsheet with data removed is attached.

My amount to be spread is in column K
Date set 1 start is in column M
Date set 1 finish is in column N
Date set 2 start is in column P
Date set 2 finish is in column Q
Date set 3 start is in column S
Date set 3 finish is in column T
Date set 4 start is in column V
Date set 4 finish is in column W

My monthly cells for the cost to be spread in are then from Column X onwards with dates in Row 3 using start date of each month

My current formula that works for just 1 date set is as follows: =IF(OR(X$3<=$M5-DAY($M5),X$3>EOMONTH($N5,0)),"",MAX(MIN(EDATE(X$3,1)-$M5,EDATE(X$3,1)-X$3,$N5-X$3+1,$N5-$M5+1),0)*$K5/($N5-$M5+1))

Any help would be greatly appreciated.

Thanks

Jack