[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Withdraw Date[/TD]
[TD]Withdraw Amt[/TD]
[TD]Daily Date (from the 1st to EOM)- I change C1 to the first each month)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8/15/2018[/TD]
[TD]$(1000)[/TD]
[TD]9/1/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]8/25/2018[/TD]
[TD][/TD]
[TD]9/2/2018[/TD]
[TD]($500)[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]9/2/2018[/TD]
[TD]($500)[/TD]
[TD]9/3/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]9/4/2018[/TD]
[TD]($2500)[/TD]
[TD]9/4/2018[/TD]
[TD]($2500)[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]9/5/2018[/TD]
[TD]($800)[/TD]
[TD]9/5/2018[/TD]
[TD]($800)[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]9/8/2018[/TD]
[TD]($5000)[/TD]
[TD]9/6/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]9/9/2018[/TD]
[TD]($4000)[/TD]
[TD]9/7/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD]9/8/2018[/TD]
[TD]($5000)[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD]9/9/2018[/TD]
[TD]($4000)[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD]9/10/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD]9/11/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD]9/12/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD]9/13//2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]...this row will continue month after month, Not Reset on the 1st[/TD]
[TD][/TD]
[TD]...All the way to 9/30/2018[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I need the formula for Row D that shows the amount of the withdraw from Row B on the corresponding date. (ie, on 9/4/2018 show the $2500 withdraw from B3 in D5. -- On 9/8/2018 show the withdraw ($5000) from B7 on D9).
Let me know if any more clarification is needed.
Thank you in advance for your time.
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Withdraw Date[/TD]
[TD]Withdraw Amt[/TD]
[TD]Daily Date (from the 1st to EOM)- I change C1 to the first each month)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8/15/2018[/TD]
[TD]$(1000)[/TD]
[TD]9/1/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]8/25/2018[/TD]
[TD][/TD]
[TD]9/2/2018[/TD]
[TD]($500)[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]9/2/2018[/TD]
[TD]($500)[/TD]
[TD]9/3/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]9/4/2018[/TD]
[TD]($2500)[/TD]
[TD]9/4/2018[/TD]
[TD]($2500)[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]9/5/2018[/TD]
[TD]($800)[/TD]
[TD]9/5/2018[/TD]
[TD]($800)[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]9/8/2018[/TD]
[TD]($5000)[/TD]
[TD]9/6/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]9/9/2018[/TD]
[TD]($4000)[/TD]
[TD]9/7/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD]9/8/2018[/TD]
[TD]($5000)[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD]9/9/2018[/TD]
[TD]($4000)[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD]9/10/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD]9/11/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD]9/12/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD]9/13//2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]...this row will continue month after month, Not Reset on the 1st[/TD]
[TD][/TD]
[TD]...All the way to 9/30/2018[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I need the formula for Row D that shows the amount of the withdraw from Row B on the corresponding date. (ie, on 9/4/2018 show the $2500 withdraw from B3 in D5. -- On 9/8/2018 show the withdraw ($5000) from B7 on D9).
Let me know if any more clarification is needed.
Thank you in advance for your time.