Calculate the proper end of month Please purchase the course before starting the lesson. The EDATE function allows you to use a specific day of the month e.g. month end is the 23rd of each month. which would result in 31 March 2005. To see the full course contents click here.