Download Excel File: https://excelisfun.net/files/EMT1620.xlsx
Learn all about how to count unique sales dates for each month. Make a Distinct Count calculations for number of unique dates in each month.
1. (00:01) Introduction
2. (00:54) Array Formula using FREQUENCY, SUMPRODUCT & IF Function
3. (04:22) Dynamic Array using FILTER and UNIQUE Functions
4. (05:48) Data Model PivotTable and Distinct Count Option
5. (08:58) Summary