View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Pivot table show all days of a month even if no data

Excel 2007, PivotTable
Show all days in time range,
including days with no data.
No extra helper rows needed.
Animated, with macro.
http://c0718892.cdn.cloudfiles.racks.../04_15_10.xlsm
Pdf preview:
http://www.mediafire.com/file/1wgfm0nym4w/04_15_10.pdf