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.
0 kommentar(er)
