Data Split based on dates

[Sahitya]

I have to populate the amount based on the value per month in the respective columns (Jan-18, Feb-18) based on the value 'Per Month' only for the duration provided (Start and End).

Start

End

Value

Value

Value

Total Value

Total Months

Per Month

Jan-18

Feb-18

Mar-18

Apr-18

May-18

Jun-18

5/3/2018

10/6/2020

$100,000.00

$180,000.00

$295,000.00

$575,000.00

29

$19,827.59

<tbody>
</tbody>

 

[Oscar Cronquist]

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​	L​	M​	N​
1​	tart	End	Value	Value	Value	Total Value	Total Months	Per Month	18-Jan​	18-Feb​	18-Mar​	18-Apr​	18-May​	18-Jun​
2​	5/3/2018​	10/6/2020​	$100,000.00​	$180,000.00​	$295,000.00​	$575,000.00​	29​	$19,827.59​					19827.59​	19827.59​

Sheet: Sheet61

Formula in cell I2:

=IF(MEDIAN($A2,$B2,EOMONTH(I1,0))-MEDIAN($A2,$B2,I1),$H$2,"")

 

[Sahitya]

it is working fine. Thank you