In the previous post, we have learned the*first day of the same month in Excel. Similarly, here we will show the formula to **get the first day of the previous month in Excel. Let’s get started!! Get an official version of * MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula:
- If you want to get the first day of the previous month, you can use the below formula.
=EOMONTH(date,-2)+1
Syntax Explanations:
- EOMONTH – In Excel, the EOMONTH function returns the last day of the month after adding/subtracting a specified number of months to a date.
- Date – It specifies the input values from your worksheet.
- Plus operator (+) – This symbol is used to add the values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Minus Operator (-) – This symbol will help to subtract any two values.
Example:
Refer to the below example image.
- First, we will enter the input values in Column B.
- Here, we are going to find the first day of the previous month.
- Select any cell and type the above-given formula.
- Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.
Conclusion:
Here, we have described the simple formulas to get the first day of the previous month in Excel. Hope you like it. Let me know if you have any doubts regarding this article or any other article on this site.
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
Top comments (0)