In this article:

How to Make a Calendar in Google Sheets [2024 Update]

May 8, 2024

Create a Calendar in Google Sheets

1. Copy the Google Sheets Calendar Generator Template by

Click the link below to copy the template:

Google Sheets Calendar Generator Template by

A tab containing a prompt asking you to copy the spreadsheet to your Google account appears. Click Make a copy.

Generate calendar google sheets

You will get a copy of the template with the following sheet:

Generate calendar in google sheets‍

2. Input the Year and the Month You Want to Generate

You need to input two quantities: the year and the month. Input the year to the cell B7 on the right of the cell with the label Year. Afterwards, select the month from the dropdown box in the cell D7 on the right of the cell with the label Month.

For our example, we want to generate the calendar for February 2024. We then input 2024 to cell B7 then select February in the dropdown box. 

google sheets generate calendar‍

3. Click Generate Calendar

Once you set the Year and the Month, click Generate Calendar.

On the first run, you will be asked to authorize the script attached to the spreadsheet. Click OK.

Authorization required to run script to generate calendar in google sheets‍

A new window will load. You will be asked first to choose the Google account that will run the script. Select the account you are using in the list. Most of the time, only the active account will be listed. 

Select account to run the generator‍

You will next get the message that Google hasn’t verified the script. Click the small link labeled Advanced. Another link will appear below it. Click Go to generatecalendar(unsafe).

Continue using the script even if it is not verified

Next, a list of permissions needed by the script will be listed. 

Click allow to let the script run with the given permissions needed

Click Allow. The window will close.

The spreadsheet now works. Click Generate Calendar again, and the results will load!

How to generate calendar in google sheets‍

Use the extra spaces to add the events and tasks for the given day.

Wanna try the template? Click here to get a copy now!

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->