Calculate the proper end of month.
The EOMONTH function tells excel to find the last day of the month based on a date you have given it and an indication of the number of months before or after this date you want to represent. The EDATE function allows you to use a specific day of the month e.g. month end is the 23rd of each month.
E.g. if you use the EOMONTH function below,
it would result in 31 March 2005.
To see the full course contents click here.