Splitting the Month into Four Periods

An Excel file that teaches how to perform Splitting the Month into Four Periods operation.

Excel Splitting the Month Into Four Periods

The date range is calculated dynamically. Weekly limits are determined by a formula. Each period is highlighted in a different color. Monthly totals are transferred to the summary table. The view is adapted to print mode.

Hope it is useful.