How to get a yearly balance in Excel Our simple data set has transactions for only one year, 2020, but that doesn’t matter. We can expect only one balance for the data set.

Excel’s Date filters are very comprehensive and allow you to extract individual or multiple dates by day, week, month, year, quarter, or year-to-date, plus dates within ranges.