dates missing rows How To Add Blank Rows For Missing Dates In Excel 10 Oct, 2021 Right-click one of the date row labels in the PivotTable select Group Days and Months. IFCOUNTBLANK C5C7 SUM C5C7 If C…