Sales transactions are almost always provided in list form with a date indicating when the transaction was completed. When analyzing sales staff efficiencies and other reporting tasks, calculating total by day of the week is especially helpful.
In this recipe, you will learn how to create an Excel formula that will total sales and display by day of the week.
The worksheet that will be used for calculations is laid out with transaction dates in column A and the corresponding transaction amount in column B. Moving horizontally from cell D2, the column labels Monday, Tuesday, Wednesday, Thursday, and Friday are listed to represent the average work week, and the heading for the calculating payment total.