Business Tools Blog

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.