If you want to create a planning calendar quick, try these formulas. I am able to create a calendar for the entire year in seconds using this method.
Click Here to link to a sample calendar. Step 1:
Type Sunday in one cell, Monday in the cell next to it.
Highlight the 2 cells and fill across to automatically show Sunday to Saturday.
Type the date underneath Sunday and push enter.
In the cell to the right of the date use the formula =B4+1 (assuming the date is in cell B4).
Fill across the formula to generate the rest of the dates of the week.
Skip a row to allow you to have a cell to type your calendar information into.
Type =B3 if you want the days of the week to repeat. Fill this across.
In the cell below the day of the week, type =B4+7 to add 7 days to the previous date. (Assuming the previous date was in B4).
Fill the formula across.
Highlight the days of the week, the dates and a blank row (the 2nd set only, not the first set).
Grab the corner of the highlighted section and pull down….. way down.