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.

Hopefully, you will take Father’s Day a little more seriously, which in the June 2022 Calendar falls on the 19th. Be sure to raise the flag if you are American!

Since she is also the goddess of marriages, that is a good reason to get married in June. June is probably named after the wife of Jupiter, Juno. In the June 2022 calendar, the moon goes through a full cycle within the month: You can download and print June calendars for 2022, 2021, 2020. The month of June always has 30 days, and we have included the following events and holidays on the June 2022 calendar: Flag Day (Tue, ), the first day of summer (Sunday, June 21) and Father’s Day (Sun, ). Each page on our June Calendar has days of the week and important holidays marked.

Blank june 2022 calendar