Find the Last Day of Any Given Month

Dates can tricky to work with, and finding the last day of a given month can be a challenge.

Following these sections:
Using Excel Formulas(Let's suppose A1 houses the date 23-Jun-2007 and you want to have Excel reference this cell and return the date of the last day of June 2007.)

Using EOMONTH

Using a Custom Function