How to get the first day of the previous month
You can easily get the first day in a previous month using MS Excel. You can perform this action by using a simple function called the EOMONTH function:
SYNTAX and EXAMPLE
The general formula that is used to determine the EOMONTH function is as follows:
=EOMONTH (date, - 2 +1)
Figure.1: Get the first day in the previous month
The figure above illustrates get the first day in the previous month. The formula used in cell B6 is as follows:
Working of the formula:
The formula works on the basis of the given date. The EOMONTH function calculates the number of days and months that it has to roll back before returning to the first day of the previous month. The function first rolls back 2 months and then add one day into that date to get the first day in the previous month.
This is a very simple function which can be widely used.