How to Find the Last Day of a Month

I want to calculate the date at the end of each month.

Solution

Explanation

To calculate the date at the end of the current month, we will use the following formula:        =EOMONTH(TODAY(),0)

To calculate the date at the end of next month, we will use the following formula:        =EOMONTH(TODAY(),1)

To calculate the date at the end of each month (shown in column A) we will use following formula:= =EOMONTH(DATE($E$1,A2,1),0)

***********************************************************

The TODAY() function returns today’s date. This function has no argument.

The DATE function converts a supplied year, month and day into an Excel date.

The syntax DATE function is: DATE( year, month, day ) where the year, month and day arguments are integers representing the year, month and day of the required date.

The EOMONTH function returns the last day of the month that is a specified number of months before or after an initial supplied start date.

The syntax of the function is: EOMONTH( start date, months ) where

start date - The initial date.

months     - The number of months (positive or negative) to add to the

                start date, before returning the last day of the resulting month.