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.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar