How to add a monthly balance in Excel As you’ve seen, a daily balance requires only a simple IF () function to match dates before returning the balance for each day.