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. This following function returns 30-Jun-2007:

This is because the function adds one month to the date in A1 (June becomes July) and uses 0 for the day, which forces Excel to return the last day of the previous month.

Or, you can hardcode the date as shown here:

Again you will get the result 30 June 2007.