Excel Magic Trick 1404

Sales Per Working Day by Month Formulas For Three Year Dynamic Report

DESCRIPTION

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:
(00:10) Introduction
(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

WORKBOOKS

Download “Excel Magic Trick 1401-1405” Excel-Magic-Trick-1401-1405.zip – Downloaded 84 times – 1 MB







Be the first to comment

Leave a Reply