# 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.

## Leave a Comment