Get the First Day of the Current Month in Excel (3 Methods)

Get FREE Advanced Excel Exercises with Solutions!

Microsoft Excel offers a handful of methods to get the first day of the current month. You can also get the first day of any random month or for the next month. In this article, you will learn 3 methods to get the first day of the current month in Excel with ease.


How to Get the First Day of the Current Month in Excel: 3 Methods

1. Combine the DATE, YEAR, MONTH, and TODAY Functions to Get the First Day of the Current Month in Excel

In this method, I will write a formula using the DATE, YEAR, MONTH, and TODAY functions to calculate the first day of the current month in Excel.

❶ First of all, insert the following formula in cell C4.

=DATE(YEAR(TODAY()),MONTH(TODAY()),1)

In this formula,

  • TODAY() returns today’s date.
  • YEAR(TODAY()) returns the current year.
  • MONTH(TODAY()) returns the current month.
  • DATE(YEAR(TODAY()),MONTH(TODAY()),1) adds 01 as day 1 with the current year and month.

❷ After that press the ENTER button.

Combine the DATE, YEAR, MONTH, and TODAY Functions to Get the First Day of the Current Month in Excel

After that, you will get the first day of the current month in cell C4.

Read More: 


2. Combine the DAY and TODAY Functions to Return the First Day of the Current Month in Excel

Now I will combine the DAY & the TODAY functions to calculate the first day of the current month in Excel.

To use the formula:

❶ Select cell C4 and write down the following formula:

=TODAY()-DAY(TODAY())+1

Here,

  • TODAY() returns the current date.
  • DAY(TODAY()) returns only the day of the current date.
  • TODAY()-DAY(TODAY())+1 subtracts today’s day from today’s date and then adds 1 as a day. Thus we get the first day of the current month.

❷ Now hit the ENTER button to execute the formula.

Combine the DAY and TODAY Functions to Return the First Day of the Current Month in Excel

After pressing the ENTER button, you will see the first day of the current month in cell C4.


Similar Readings:


3. Join the EOMONTH & TODAY Functions to Get the First Day of the Current Month in Excel

In this section, I will combine the EOMONTH and the TODAY functions to write a formula to get the first day of the current month in Excel.

For getting the first day of the current month,

❶ First insert the following formula in cell C4.

=EOMONTH(TODAY(),-1)+1

In this formula,

  • TODAY() returns the current date.
  • EOMONTH(TODAY(),-1) returns the last day of the previous month.
  • EOMONTH(TODAY(),-1)+1 adds 1 to the last day of the previous month. Thus, we get the first day of the current month.

❷ Now press the ENTER button.

Join the EOMONTH & TODAY Functions to Get the First Day of the Current Month in Excel

After pressing the ENTER button, you will see the first day of the current month in cell C4.

Read More: Excel Formula for Current Month and Year


Get the First Day of the Any Month in Excel

If you are looking for formulas to get the first day of any month in Excel, then follow the steps below:

❶ Insert the following formula in cell C5.

=B5-DAY(B5)+1

Here,

  • B5 contains the input data.
  • DAY(B5) extracts the day from the date in cell B5.
  • B5-DAY(B5)+1 subtracts the day from the date in cell B5 and then adds 1. Thus, we get the first day of any given month in Excel.

❷ Now press the ENTER button to insert the formula.

Get the First Day of the Any Month in Excel

❸ Put the mouse cursor at the right-bottom corner of the cell where you’ve inserted the formula.

A plus-like icon called the “Fill Handle” will appear.

❹ Drag the Fill Handle icon from cell C5 to C12.

Now you will get the first day of the all input dates just like the picture below:

Get the First Day of the Any Month in Excel


Download Practice Workbook

You can download the Excel file from the following link and practice along with it.


Conclusion

To sum up, we have discussed 3 methods to get the first day of the current month in Excel. You are recommended to download the practice workbook attached along with this article and practice all the methods with that. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap.


Related Articles

Mrinmoy Roy
Mrinmoy Roy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo