WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to get the first day of the month in Excel

July 22, 2022
11.2K Views

The first day of the month is one of the most important dates in any calendar. It is used for banking days and government employee reimbursement, school reports, and rent payments. But how do you get it while working with Excel? We all know that Excel is one of the most widely used apps for any kind of professional or personal use. There are the advantages and disadvantages to this, which we'll discuss later on. For now, let's just say this: Excel has something useful for everyone

In this article, we'll learn how you can get the first day of the month in excel. There are several ways to do this. Many people face the issue of how to get the first day of the month in excel. Once you will have this information, you can easily solve your problems of how to get the first day of the month in excel.

Tips that are provided in this article are compatible with versions 2010/2013/2016.

How to get the first day of the month in Excel: Using the Day function

The first formula that we can use to get the first day of the month is the following

=date-DAY(date)+1

This formula when applied on a certain date returns the first day of the month, it’s a very easy one

  1. Open the excel

2.Select the date.

3.Put this function inside the formula bar

=A2-DAY(A2)+1

4/1The result as you can see is the first day of the month.

How to get the first day of the month in Excel: Using the EOMONTH function

The next method to get the first day of the month in Excel is by using the EOMONTH function, EOMONTH function helps in finding the end of the month but we can modify this function in our way so that it will return us the first day of the month

1.The syntax of this formula is

=EOMONTH(A2,-1)+1

2.This will give us the first day of the month that we are looking for.

3.Now let’s apply the formula.

4.You can see the result we get is the first day of that month.

How to format cells to get the first day of the month:

One thing that you guys might have noticed is that the answers aren’t the same as in our case, but it’s in the form of some numbers, if  we apply the formula given above, what you get is this:

No, that doesn’t mean that your answer  is wrong, all you have to do is to do some little cell formatting  to get to the right answer

Here is how you can do this

1.Left-click the cell, choose the option format cell.

2.Then choose  the Date option from it and the required formatting style.

3,And that’s it, you have successfully got the first day of the month in excel.

Did you learn about how to get the first day of the month in Excel? You can follow WPS academy to learn more features of Word documents, Excel Spreadsheets, and PowerPoint slides.

You can also download WPS office to edit the word documents, Excel Spreadsheets, and PowerPoint free of cost. Download Now! And get an enjoyable working space.

 

 

 

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.