Tip Printed from ExcelTip.com

---

Finding the Last Day of a Given Month


Problem:

Calculating the date at the end of the current month, as well as the date at the end of each month (serial number) listed in column A.

Solution:

To calculate the date at the end of the current month, use the EOMONTH and TODAY functions as shown in the following formula:
=EOMONTH(TODAY(),0)

To calculate the date at the end of next month, use the EOMONTH and TODAY functions as shown in the following formula:
=EOMONTH(TODAY(),1)

To calculate the date at the end of each month listed in column A, use the DATE function as shown in the following formula:
=DATE(2005,A2+1,0)