Sometimes you need to determine the last day of a future month. Here is an easy way to do that in Excel. We’ll utilize the DAY, MONTH and YEAR functions in the process.
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.