/docs/community?hl=en
This content is likely not relevant anymore. Try searching or browse recent questions.
I need a 2020 Calendar template for Google Sheets. Similar to what they have for 2018 and 2019.
4
How can I create one?

Ideally the template should have a parameter to change the year and it auto-generates the template for that year, instead of waiting for Google to upload the template for the next year.

I have tried a bunch of templates that are available online, none of them are as good and neat as the one published by Google. I would very much appreciate if Google publishes a template for 2020 Calendar.

Thanks!
Details
Pinned
Locked
Latest Update Latest Updates (0)
Relevant Answer Relevant Answers (0)
All Replies (232)
Relevant Answer
if you make a new sheet & share "anyone with link - can edit" - will copy over a few sheets - once finished
may be what u need - but then may not - as u dont specify
marked this as an answer
Relevant Answer
Thank you so much!!!
marked this as an answer
Relevant Answer
@James/mreighties

THANK YOU!!!

This has saved me many hours of work!!!

I was wondering if you can teach me how you did this?

I wanted to create a calendar with few more custmoizations and a different color theme for each year (as you can see in 2018 and 2019). The colors are in 'a nice to have' category.

Thank You! Thank You! Thank You!

I am using the current script for my needs to make it easier on the dates when events are scheduled, primarly, Suns, Thus and Fris.

/** @OnlyCurrentSheetsInCurrentSpreadSheet */

function FixDates() {
  var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
 
  for (var i = 0; i < sheets.length; i++) {
    var sheet = sheets[i];
    if (sheet.getName() == 'Yearly') continue;
   
    // set every date cell color to gray, and horizontal alignment to left
    sheet.getRangeList(['B4:H4', 'B6:H6', 'B8:H8', 'B10:H10', 'B12:H12', 'B14:H14']).activate();
    sheet.getActiveRangeList().setFontColor('#999999');
    sheet.getActiveRangeList().setHorizontalAlignment('left')
   
    // only set sun, thu and fri font color to black, and font to bold
    sheet.getRangeList(['B4', 'F4', 'G4','B6', 'F6', 'G6','B8', 'F8', 'G8','B10', 'F10', 'G10','B12', 'F12', 'G12','B14', 'F14', 'G14']).activate();
    sheet.getActiveRangeList().setFontColor('#000000');
    sheet.getActiveRangeList().setFontWeight('bold');
   
    // freeze headers
    sheet.setFrozenRows(3);
   
    // delete Notes rows
    sheet.getRange('16:24').activate();
    var activeRange = sheet.getActiveRange();
    if (activeRange === null) continue;
    sheet.deleteRows(activeRange.getRow(), activeRange.getNumRows());
  };
};
marked this as an answer
Relevant Answer
 I need help, i'm trying to type into the boxes for each day (to record daily numbers for work) but i do not want the text to be a note. When I type into the boxes the text disappears.
marked this as an answer
This question is locked and replying has been disabled.
Discard post? You will lose what you have written so far.
Write a reply
10 characters required
Failed to attach file, click here to try again.
Discard post?
You will lose what you have written so far.
Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.
Create Reply
Edit Reply
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
Report abuse
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
Report post
What type of post are you reporting?
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
This reply is no longer available.
/docs/threads
//accounts.google.com/ServiceLogin
You'll receive email notifications for new posts at
Unable to delete question.
Unable to update vote.
Unable to update subscription.
You have been unsubscribed
Deleted
Unable to delete reply.
Removed from Answers
Removed from Updates
Marked as Recommended Answer
Marked as Update
Removed recommendation
Undo
Unable to update reply.
Unable to update vote.
Thank you. Your response was recorded.
Unable to undo vote.
Thank you. This reply will now display in the answers section.
Link copied
Locked
Unlocked
Unable to lock
Unable to unlock
Pinned
Unpinned
Unable to pin
Unable to unpin
Marked
Unmarked
Unable to mark
Reported as off topic
Known Issue
Fixed
Marked Fixed
Unmarked Fixed
Unable to mark fixed
Unable to unmark fixed
/profile/0
false
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false