Home / MS-Excel / Functions and Formula

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

In this tutorial:

  1. Using Excel Formulas
  2. Using EOMONTH
  3. Using a Custom Function