You can use the following formula in Google Sheets to find the first Monday of a given month:

=DATE(YEAR(A2),MONTH(A2),7)-WEEKDAY(DATE(YEAR(A2),MONTH(A2),7),3)

This particular example returns the first Monday of the month for the date in cell **A2**.

The following example shows how to use this formula in practice.

**Example: Find First Monday of Month in Google Sheets**

Suppose we have the following list of dates in Google Sheets:

We can type the following formula into cell **B2** to find the first Monday of the month for the date in cell **A2**:

=DATE(YEAR(A2),MONTH(A2),7)-WEEKDAY(DATE(YEAR(A2),MONTH(A2),7),3)

We can then click and drag this formula down to each remaining cell in column B:

Column B now contains the date of the first Monday of each month in column A.

For example, the first date of **1/1/2023** contains the month of January for 2023.

We can confirm that **1/2/2023** is indeed the first Monday of this month by referring to a calendar:

Similarly, the second date of **2/1/2023** contains the month of February for 2023.

We can confirm that **2/6/2023** is indeed the first Monday of this month by referring to a calendar:

**How This Formula Works**

Recall the formula that we used to find the first Monday of the date 1/1/2023:

=DATE(YEAR(A2),MONTH(A2),7)-WEEKDAY(DATE(YEAR(A2),MONTH(A2),7),3)

Here is how this formula works:

First, we use **DATE(YEAR(A2),MONTH(A2),7)** to extract the seventh day of the month and year in cell **A2**.

This returns **1/7/2023**.

Next, we use the **WEEKDAY** function with the optional argument of **3** to specify that we would like to extract the number of the day of the week of **1/7/2023**, assuming that the days are number from 0 (Monday) to 6 (Sunday).

This returns **5** since **1/7/2023** is on a Saturday.

Lastly, we use a subtraction sign to subtract **5** from **1/7/2023** to get **1/2/2023**.

We use the same process to find the first Monday of each date in column A.

**Note**: You can find the complete documentation for the **WEEKDAY** function in Google Sheets here.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Google Sheets:

Google Sheets: Calculate the Number of Weeks Between Dates

Google Sheets: How to Get First Day of Week

Google Sheets: How to Get Date from Week Number