Free Practice WorkbookWhat does it do?
Returns the last day of the month after a start date
Formula breakdown:
=EOMONTH(start_date, months)
What it means:
=EOMONTH(Your Start Date, enter 0 for current end of month, 1 for the next end of month, and so on…)
The EOMONTH (EndOfMonth) function in Excel is one that most people do not use because they just don’t know that it exists.
It is a great Excel function to use if you want to see when the month end date is from a current date’s value.
So if you have sales reps who make a sale during the month and their commission is due to be paid at the end of the next month, the EOMONTH function will help you determine the total sales due.
STEP 1: We need to enter the EOMONTH function in a blank cell:
=EOMONTH(
STEP 2: The EOMONTH arguments:
Table of Contents
start_date
What is your start_date?
=EOMONTH(B12,
months
Which end of month do you want?
We can type in 0 for the current End of Month, or 1 for the next End of Month, and so on.
=EOMONTH(B12, 1)
Apply the same formula to the rest of the cells by dragging the lower right corner downwards.
You now have all of results!
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.
30 Days - Full Access 
