The EOMONTH and EDATE Functions
In this video we show how to use the EOMONTH function to find the last day of a given month and how to use the the EDATE function to move ahead or behind several months from the given date.
These are the two files needed to follow along to this video: