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.

DOWNLOAD WORKBOOK

EOM

HELPFUL RESOURCE:

 

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Autosum an Array of Data in Excel When you have an array of data in Excel with Totals at the bottom and to the right of the data, you can quickly fill in the Totals with the Autosum button.STEP 1: Highlight your data including the "Totals" row and column;STEP 2: Click the Autosum button (under the Home or...
Create a Dynamic Data Range with the OFFSET functi... What does it do?It returns a reference to a range, from a starting point to a specified number of rows, columns, height and width of cellsFormula breakdown:=OFFSET(reference, rows, columns, , )What it means:=OFFSET(start in this cell, go up/down a number o...
Advanced SUMPRODUCT Function: Sum Multiple Criteri... What does it do?It returns the sum of multiple criteria from the corresponding ranges or arraysFormula breakdown:=SUMPRODUCT((array 1 criteria) * (array2 criteria) * array values)What it means:=SUMPRODUCT((find my criteria in this array) * (find my criteri...
VLOOKUP Multiple Columns What does it do?Searches for a value in the first column of a table array and returns the sum of values in the same row from other columns (to the right) in the table array.Formula breakdown:{=SUM(VLOOKUP(lookup_value, table_array, {col_index_num1,col_index_num2}, ))}...