Go Back

Get first day of previous month

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:

=EOMONTH(B6,-2)+1

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.

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