What do you use spreadsheets for?
If you’re anything like me, you likely make use of them to collect data, monitor campaign or article analytics, or keep track of weekly assignments.
But have you ever thought about using spreadsheets to produce a calendar?
Plus, more specifically, maybe you have thought about using Google Sheets to make a useful calendar?
If you usually work on campaigns for some different clients, producing individual calendars in Google Sheets could be distinctively useful for ensuring the customer understands when particular content will go reside. Alternatively, perhaps you have to create an internal Google Sheet calendar for the team to keep track associated with upcoming projects.
Making a calendar within a tool that’s commonly used for spreadsheets sounds a little intimidating, but don’t worry, the procedure is actually pretty user-friendly. And with the help associated with some tips, you can easily make a functional calendar that you can sync your schedule with.
Below, we’ll review how to make a diary in Google Sheets including some tips that’ll help you elevate the style. At the end, your diary will look something like this:
So begin a new spreadsheet and obtain ready to create your very own calendar. 📅
1 . Open a brand new spreadsheet and choose your month.
First, open a new spreadsheet. Then, remove columns H — Z. They won’t be needed.
After that, choose your month. For this example, I actually decided to do The month of january 2021, so I stuffed that into the 1st cell. What’s great about Google Bedding is that it automatically recognizes dates, so inputting in a month, accompanied by the year in YYYY format will tell Google that you’re going to be working with dates.
2 . Start to format your calendar.
Next, structure your calendar. We selected the text, The month of january 2021, in Line A, Row 1 ) I highlighted seven columns (A-G), plus clicked Merge to make that cell span across the whole column. You can find this button to the right of the Fill tool.
Here, I also center-aligned my textual content using the tool next to Merge. Then, I actually increased the font size and bolded the month.
3. Use a formulation to fill in the times of the week.
Next, fill in the days of the week within each column (A-G). You can do this manually but I decided to utilize a formula. Sheets includes a function that allows you to type in formulas to complete certain actions at the same time.
To complete days of the 7 days, in the cell where you want your first weekday to be, type: =TEXT(1, “DDDD”) . What this particular tells Google is that your number will be changed by a date or time and the format you’re using can be weekdays.
Highlight the number 1 in the formula and replace it with: COLUMN() . Then, press enter and select your first day time. You’re going to copy the particular formula in Sunday’s cell by dragging the selector to the end of your row, (A-G), and pushing enter again.
Pressing enter should automatically fill in the rest of the week. Remember, if this doesn’t work for you, you are able to fill in the days manually.
Pressing enter should automatically fill in the rest of the week. Keep in mind, if this doesn’t work for you personally, you can always fill in the times manually.
four. Fill in the numbers.
Excellent! You might have your days of the particular week. Now we will fill in the numerical values. Before this step, I took the time to add color to the days row and transformed the font to 1 I liked a little more.
For the statistical values, we’ll just identify the first day from the month and click and drag to fill in the others.
Place the number one on the box correct underneath the first day of the month, the click and pull horizontally.
5. Fill in the rest of the quantities.
Take note : In this stage, I filled in the calendar numbers every other row to help with my formatting later on.
Now that you’ve filled out your first row, it’s time to complete the rest. Manually put in the next number below “Sunday, ” then click and drag horizontally to fill in the rest.
Repeat the process for the next rows. You’ll insert the first number manually, the click and drag down the line. Here’s what that will looks like for the next row in January.
Note : Make sure to end the particular month on the correct number! For The month of january, that would be the 31st.
6. Reformat your calendar if required.
Everything can be starting to look like a diary, right? At this stage, We reformatted things to clean up the look of the calendar a little.
Remember those extra rows in between the particular numbered rows? I expanded those series to create boxes underneath the numbers. To do this, I simply dragged the series down to make those people cells bigger.
Here are some additional formatting tips :
- Select the empty rows underneath your numbers and center them using the center text alignment tool.
- Select your whole calendar and vertically arrange all of the elements so that they’re in the center of their tissues. To do this, use the top to bottom alignment tool.
- Bold your day numbers.
- If desired, gently shade your numbered rows.
- If preferred, grey out the Saturday plus Sunday columns so that your workdays stand out.
7. Add design elements to professionalize the look.
Lastly, you can add in some enjoyable design elements in order to personalize the look plus feel of your diary. If it’s for a client or upcoming project, you’ll want to incorporate necessary launch days here.
For this step, We added in a few enjoyable images, included a few hypothetical calendar events, and played with font sizes.
6. Repeat the process from Feb to December.
It’s time to do it again for the month associated with February to December. Simply duplicate your January calendar once you’ve designed this how you want it to look. To do this, right click the sheet’s tab and choose Duplicate from your menu.
To fill in the particular numbers, you’ll only need to know the beginning day, then click plus drag to complete the rest of the rows. Here are the very first days for every 30 days for the year 2021:
- January : Friday
- February : Monday
- March : Monday
- April : Thursday
- May : Sunday
- June : Tuesday
- July : Thursday
- August : Weekend
- September : Wednesday
- October : Friday
- November : Monday
- December : Wednesday
Next, you’ll would like to know how many days you will need to fill in. Here are the number of days you’ll requirement for each month:
- The month of january : 31
- February : 28 or twenty nine
- March : 31
- April : 30
- May : thirty-one
- 06 : 30
- July : 31
- August : 31
- September : 30
- October : 31
- November : thirty
- Dec : 31
And then, you’re performed!
It’s useful to use Sheets since you can open your own calendar right on your own browser. You can also keep an eye on your schedule within a place that’s individual from your phone.
Alternatively, you can develop important business paperwork such as social and editorial calendars. Below, I share the template that’s ideal for the task.
Google Sheets Calendar Template
Here’s an editorial calendar template for all of your editorial planning needs. This template helps you lay out a strong editorial strategy on a daily basis.
Showcased Resource: Free Content Calendar Templates
Download the Free Templates
Use a Google Sheets Calendar to Organize Your Tasks
If you’re handy along with Sheets and want to give it a shot, create a Google Bedsheets calendar. It’s a great option if you need to build a clean calendar to an internal marketing campaign, manage a client’s forthcoming projects, or share an event calendar along with key stakeholders. In case you don’t want to create one from scratch, use our editorial calendar template in order to jumpstart your preparing and organization efforts immediately.
Editor’s note: This post was originally published in May 2020 and has been updated meant for comprehensiveness.