Excel formula for average balance

Average balances are closely associated with bank transactions and credit cards. One can easily calculate his or her average balance depending on the amounts spent. 1. Simple average balance One can find the average balance by simply taking the initial balance and adding it to the final balance and then dividing the result by two