I have a table of data where the top row contains this month's dates, and the
cell beneath each date contains a bank balance. Can you please help me
create a formula to put in the far right column(directly after the last date
of the month) that will return the value of the second to last bank balance I
have entered.

For example, today (7/24) I entered a balance, so I want the formula to
automatically update with the bank balance of 7/23.

Thanks in advance!