Mr. Captoon Caricature answered question 12/12/2011 What formula would you use to calculate the average of your monthly expenses in Excel? Just add up the total expenses of the month, and divide by the number of days in the month.