Click the link below to copy the template:
A tab containing a prompt asking you to copy the spreadsheet to your Google account appears. Click Make a copy.
You will get a copy of the template with the following sheet:
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.
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.
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.
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).
Next, a list of permissions needed by the script will be listed.
Click Allow. The window will close.
The spreadsheet now works. Click Generate Calendar again, and the results will load!
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!
Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.