Pinterest Pixel

Excel´s EndOfMonth function

  What does it do? Returns the last day of the month after a start date Formula... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

 

What 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.

Excel´s EndOfMonth function | MyExcelOnline

Download excel workbookEOM.xlsx

STEP 1: We need to enter the EOMONTH function in a blank cell:

=EOMONTH(

Excel´s EndOfMonth function

 

STEP 2: The EOMONTH arguments:

start_date

What is your start_date?

See also  Match Two Lists With The MATCH Function

=EOMONTH(B12,

Excel´s EndOfMonth function

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)

Excel´s EndOfMonth function

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

Excel´s EndOfMonth function

You now have all of results!

Excel´s EndOfMonth function

How to Use the EOMONTH Formula in Excel

 

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!