Go Back

Get first day of previous month

Figure 1. Get First Day of Previous Month in Excel.

If we are required to get the first day of a previous month in Excel, we are going to utilize the EOMONTH function.

Generic Formula

=EOMONTH(date,-2)+1

The EOMONTH function operates by calculating the amount of days and months that it must roll back before determining the first day of the previous month.

How to use the Excel EOMONTH function.

The EOMONTH function operates by calculating the amount of days and months that it must roll back before determining the first day of the previous month. It starts by rolling back 2 months, then proceeds to add 1 day to that particular date which gives us the first day occurring in the previous month.

We are going to demonstrate how we can use the Excel EOMONTH function in 3 simple steps;

  1. Arrange the dates we are going to check out in a labeled column of our worksheet. Be sure to make provision for the empty cells where Excel will return our results.

See example illustrated below;

Figure 2. Get The First Day of Previous Month in Excel.

  1. In our example above, our EOMONTH formula to be entered into cell B2 is as follows;

=EOMONTH(A2,-2)+1

Figure 3. Get The First Day of Previous Month in Excel.

  1. Excel returned the first date result as 12/1/2017. In order to get the other dates, copy a modified version of the EOMONTH formula in cell B2 then enter into the other cells in the PREVIOUS MONTH column.

Figure 4. Get The First Day of Previous Month in Excel.

The last day of a month based on a given date can be determined by the Excel EOMONTH function.

We can calculate the first day of the previous month from any given date traveling back 2 months, then adding one day.

Figure 5. Final Result.

Instant Connection to an Expert through our Excelchat Service:

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

I have a monthly spreadsheet broken down day by day. I want the last day of the month on one sheet to connect to the first day of the month on the next sheet so that the data is continuous, but just on different sheets. Many thanks
Solved by C. U. in 21 mins
I need to have all the days in the month change over automatically for a particular month when i enter in the first day of the month
Solved by B. J. in 13 mins
every month I get a very large list of recalls. and most of the time it is the same vin numbers from the previous month. is there any way I can have the previous month selected and if there is a duplicate of the vin then to copy it onto my new month sheet?
Solved by C. B. in 20 mins

Leave a Comment

avatar