Change the cell value based on changing date

[SAPkannan]

I want to change the cell value automatically on daily basis based on
the change in date. for eg.

A1 = Opening balance
A2 = Deposit
A3 = Transaction
A4 = Closing balance

when the next day comes the opening balance should change as previous
day's closing balance.

Please help me in writing code for this.

Thanks in advance.

Kannan