Mrinmoy Roy
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.
Download Practice Workbook
You can download the Excel file from the following link and practice along with it.
3 Methods to Get the First Day of the Current Month in Excel
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.
After that, you will get the first day of the current month in cell C4.
Read More: Excel VBA: First Day of Month (3 Methods)
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())+1Here,
- 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.
After pressing the ENTER button, you will see the first day of the current month in cell C4.
Related Content: How to Get First Day of Month from Month Name in Excel (3 Ways)
Similar Readings:
- How to Convert a Date to dd/mm/yyyy hh:mm:ss Format in Excel
- Get Last Day of Previous Month in Excel (3 Methods)
- How to Convert 7 Digit Julian Date to Calendar Date in Excel (3 Ways)
- Stop Excel from Auto Formatting Dates in CSV (3 Methods)
- How to Calculate First Day of Previous Month in Excel (2 Methods)
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)+1In 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.
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 (3 Examples)
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)+1Here,
- 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.
❸ 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:
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. And please visit our website Exceldemy to explore more.
