We’ll skip rows to make our design easy to read. Here’s what that looks like for the next row in January. You’ll insert the first number manually, then click and drag down the row. Manually insert the next number under “Sunday,” then click and drag horizontally to fill in the rest. Now that you’ve filled out your first row, it’s time to fill in the rest. Depending on the day of the week, you may need to follow this process using the second day of the month so you can click and drag horizontally.įor this example, we’ll use Sunday as the first day of the month, but remember that the first day will vary from year to year. Place the number 1 on the box right underneath the first day of the month, then click and drag horizontally. Before this step, I took the time to add color to the days row and changed the font to one I liked a little more.įor the numerical values, we’ll simply identify the first day of the month and click and drag to fill in the rest. Now we're going to fill in the numerical values. Fill in the numbers.Įxcellent! You have your days of the week. Remember, if this doesn't work for you, you can always fill in the days manually. Pressing enter should automatically fill in the rest of the week. You're going to copy the formula in Sunday's cell by dragging the selector to the end of your row, (A-G), and pressing enter again. Then, press enter and select your first day. Highlight the number 1 in the formula and replace it with: COLUMN(). This tells Google that you will be adding days of the week. If you're looking to use a formula, type =TEXT(1, "DDDD") in the cell where you want your first weekday to be. You can do this manually or use a formula. Next, fill in the days of the week in each column (A-G). Use a formula to fill in the days of the week. Then, increased the font size and bold the month if desired.
You can find this button to the right of the Fill tool.Ĭenter-align your text using the tool next to Merge. Then, highlight seven columns (A-G), and click Merge to make that cell span across the entire column. Select your text, (in this case, January 2022) in Column A, Row 1. Typing in a month, followed by the year in YYYY format will tell Google that you're going to be working with dates. What's great about Google Sheets is that it automatically recognizes dates. For this example, let’s start with January 2022, so I filled that into the first cell. Open a new spreadsheet and choose your month. Repeat the process from February to December.ġ.Use a formula to fill in the days of the week.Open a new spreadsheet and choose your month.
0 kommentar(er)
