How to Get the First Day of the Month in Google Sheets

In this article, I’m going to show you how to get the first day of the month in Google Sheets using simple formulas. Whether you’re a novice or experienced user, these tricks will help improve your productivity when working with dates in Google Sheets.

Formula 1: Using the DAY() Function

The first formula we’re going to look at uses the DAY() function to get the first day of the month. Here’s how to use it:

=A2-DAY(A2)+1

In this formula, you can replace A2 with the cell containing your date. For example, if your date is in cell B2, you would use the following formula:

=B2-DAY(B2)+1

Formula 2: Using the EOMONTH() Function

The second formula we’re going to see uses the EOMONTH() function to get the first day of the month. Here’s how to use it:

=EOMONTH(A2,-1)+1

Again, you can replace A2 with the cell containing your date.

Now that we’ve seen how to use these formulas, let’s take a look at some practical examples.

Example 1: Using the DAY() Formula

Let’s say you have a column containing dates in Google Sheets, and you want to get the first day of each month for each date. Here’s how you can do it:

1. Enter the following formula in cell C2:

=A2-DAY(A2)+1

2. Drag this formula down to fill the remaining cells in column C.

Now, you will see that column C displays the first day of each month for each date in column A.

Example 2: Using the EOMONTH() Formula

Now, let’s say you prefer to use the EOMONTH() function to get the first day of each month. Here’s how you can do it:

1. Enter the following formula in cell C2:

=EOMONTH(A2,-1)+1

2. Drag this formula down to fill the remaining cells in column C.

Again, you will see that column C displays the first day of each month for each date in column A.

And there you have it! Now you know how to get the first day of the month in Google Sheets using these simple formulas.

If you want to learn more about the EOMONTH() function in Google Sheets or discover other useful tips, I invite you to check out the complete documentation here.

I hope this article has been helpful in efficiently managing dates in your Google spreadsheets. If you have any questions or comments, feel free to share them with us.