Explanation
The EOMONTH function returns the last day of a month based on a given date. The 2nd argument is months, which specifies how many months in the future or past to move before returning the last day. By traveling back 2 months, then adding one day, we can calculate the first day of the previous month from any given date.
In the example shown, months is supplied as -2, which causes EOMONTH to return 4/30/2015. Then, 1 day is added to get 5/1/2015.
Related formulas
Get first day of month
In this example, the goal is to get the first day of the month based on any valid date. This problem can be solved by combining the EOMONTH function with simple addition. The EOMONTH Function The EOMONTH function returns the last day of the month, a given number of months in the past or future. For...
Get last day of month
In this example, the goal is to get the last day of the month based on any valid date. This problem can be solved most easily with the EOMONTH function. However, it can also be solved with the DATE function as explained below. The EOMONTH function The EOMONTH function returns the last day of the...
Related functions
EOMONTH Function
The Excel EOMONTH function returns the last day of the month, n months in the past or future. You can use EOMONTH to calculate expiration dates, due dates, and other dates that need to land on the last day of a month. Use a positive value for months to move forward in time, and a negative number...
