Download File: https://excelisfun.net/files/EMT1404.xlsx
See how to create a three-year Sales per Working Day by Month Report Where the Date Table lists the Working Days and the Sales Table will be updated with new data regularly:
1. (00:10) Introduction
2. (01:29) Date Formulas for Upper and Lower Limit. See EOMONTH Function
3. (03:42) SUMIFS Function for Total Sales by Month, or Year or Grand Total
4. (06:02) COUNTIFS & MAXIFS for Number of Working Days by Month, or Year or Grand Total. Also see AGGREGATE and MAX IF Array Formula.
5. (11:36) IF Function for Sales per Working Day by Month or Year or Grand Total