Opening and Closing balance should be constant when day wise calculation done

We have A B C column

in A = Opening Balance that is last day closing balance

B = Total A+something

C= B-something

Now when i use this calculation then circular ref. occur

make formula for same and opening balance will be previous day of closing

sheet will make day wise , like total 30 days single sheet

when select any month then previous month closing should be constant that use opening balance of 1st date.