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:
(01:29) Date Formulas for Upper and Lower Limit. See EOMONTH Function
(03:42) SUMIFS Function for Total Sales by Month, or Year or Grand Total
(06:02) COUNTIFS & MAXIFS for Number of Working Days by Month, or Year or Grand Total. Also see AGGREGATE and MAX IF Array Formula.
(11:36) IF Function for Sales per Working Day by Month or Year or Grand Total