You’ll often find that you need to show the end of the month in data analysis or when setting up a forecast template. The EOMONTH command is the right tool for this job.
First, make sure your addins are turned on:
- Goto Tools
- Add-Ins…
- Select Analysis ToolPak and Analysis ToolPak - VBA
- Click OK
Next type the EOMONTH command:
- +EOMONTH(B4,1)
- The formula takes the date in cell B4, adds 1 month and reports the last day in that month.
Next format the date.
- Here the Mar-01 date is used. This would be an appropriate date for a forecasting template.
Then, copy the formula to the right:
- Click the little black box in the lower right corner of the cell that you wish to copy
- Then, drag that cell to the right.
Each cell now shows the last day of each successive month.
Note - +EOMONTH(B4,0) would have shown the last day of the current month.
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare