How to subtract balances at certain data date?

Question

Hi,

Seeking help to write a formula to subtract Amount at Date 8/29/25 from Amount at Date 9/30/25 or any other Date in the example below.

DateAmount7/31/25100,0008/29/25500,0009/30/25200,000

Thank you

MinhLO · Accepted Answer

Hey @Falnangel ,

Please find below:

1) Clean Data

2) Prep Data

3) Calculation

4) Output

Hope it helps!

I also added a running total to show you another way to sum data :)