How to obtain last date in a month via Microsoft Excel's Function?

I have just discovered that Ms Excel provides function that will automatically output the last date in a month via the EOMONTH function. If you link this function to a cell with any date, it will output you the end of month's date. This is a very convenient tool and I’d like to share with you a guide on how to use this.

First, search for EOMONTH under Help.

Copy the sample in the help file as follows.

This means that you have not installed the add ins - Analysis Tool Pack. You can do so by: From Excel's menu - Tool > Add ins and you will see this. Put a check to the Analysis ToolPak. You many need to insert the microsoft installer disc.

What if it shows #value! like follows or even error code like #NAME?.

This means you haven't refresh the cell yet. You can do so by double clicking the cell and press ENTER.

I hope this is useful, you may contact me at amandayno@gmail.com if you like to know more. Thanks.