Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Quick, Easy and Amazing: Make a Calendar in Google Spreadsheet

Quick, Easy and Amazing: Make a Calendar in Google Spreadsheet

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.

Step 2:

Type the date underneath Sunday and push enter.

Step 3:

In the cell to the right of the date use the formula =B4+1 (assuming the date is in cell B4).

Step 4:

Fill across the formula to generate the rest of the dates of the week.

Step 5:

Skip a row to allow you to have a cell to type your calendar information into.

Step 6:

Type =B3 if you want the days of the week to repeat. Fill this across.


Step 7:

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.

Step 8:

Highlight the days of the week, the dates and a blank row (the 2nd set only, not the first set).

Step 9:

Grab the corner of the highlighted section and pull down….. way down.




© 2024 All Rights Reserved.

❤️ Become a Premium Teacher Tech Member

Regular price is $249. Save $150 and pay only $99 for the 2024/2025 school year!

Monthly installments is only $12 a month.

Exclusive Teacher Tech Content! 
Exclusive Online Courses
Premium Add-ons for Google Workspace
Office Hours with Alice
Weekly Check In Support
Exclusive Webinars
And more! 

Exit this pop up by pressing escape or clicking anywhere off the pop up.