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).



[TABLE="class: grid, width: 1255"]
<tbody>[TR]
[TD]Start[/TD]
[TD]End[/TD]
[TD]Value[/TD]
[TD]Value[/TD]
[TD]Value[/TD]
[TD][/TD]
[TD][/TD]
[TD]Total Value[/TD]
[TD]Total Months[/TD]
[TD]Per Month[/TD]
[TD][/TD]
[TD]Jan-18[/TD]
[TD]Feb-18[/TD]
[TD]Mar-18[/TD]
[TD]Apr-18[/TD]
[TD]May-18[/TD]
[TD]Jun-18[/TD]
[/TR]
[TR]
[TD]5/3/2018[/TD]
[TD]10/6/2020[/TD]
[TD="align: right"]$100,000.00[/TD]
[TD="align: right"]$180,000.00[/TD]
[TD="align: right"]$295,000.00[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$575,000.00[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]$19,827.59[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Oscar Cronquist]

[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][th]

I​

[/th][th]

J​

[/th][th]

K​

[/th][th]

L​

[/th][th]

M​

[/th][th]

N​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]tart[/td][td]End[/td][td]Value[/td][td]Value[/td][td]Value[/td][td]Total Value[/td][td]Total Months[/td][td]Per Month[/td][td]

18-Jan​

[/td][td]

18-Feb​

[/td][td]

18-Mar​

[/td][td]

18-Apr​

[/td][td]

18-May​

[/td][td]

18-Jun​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

5/3/2018​

[/td][td]

10/6/2020​

[/td][td]

$100,000.00​

[/td][td]

$180,000.00​

[/td][td]

$295,000.00​

[/td][td]

$575,000.00​

[/td][td]

29​

[/td][td]

$19,827.59​

[/td][td][/td][td][/td][td][/td][td][/td][td]

19827.59​

[/td][td]

19827.59​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet61[/td][/tr][/table]

Formula in cell I2:

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

 

[Sahitya]

it is working fine. Thank you