### Highline Excel 2013 Class Video 31

April 14, 2017

Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More DESCRIPTION Topics in this video: 1. TODAY function to put in today’s date so that it updates each day. 2. NOW to put in today’s date […]

### Dueling Excel 137

April 12, 2017

DESCRIPTION Start and End Date, What is Total Pay Over Period Given Month Salary? See Mr Excel and excelisfun use two methods to calculate Start and End Date, What is Total Pay Over Period Given […]

### Excel Magic Trick 1270

February 13, 2017

DESCRIPTION Calculate Retirement Date with EDATE and EOMONTH functions Learn how to Calculating Retirement Date with EDATE and EOMONTH functions. The rule for calculating the retirement date is: 1. Retirement age is 60 years. 2. […]

### Dueling Excel 120

November 23, 2016

DESCRIPTION Summarize By Week and Month, Monthly Totals, Weekly Totals See Mr Excel and excelisfun use two methods to Summarize By Week and Month: 1. See two methods that use SUMIFS, EOMONTH, WEEKDAY and other […]

### Excel Magic Trick 1198

March 28, 2016

Median for Each Quarter Using AGGREGATE Function DESCRIPTION See how to calculate Median for Each Quarter Using AGGREGATE Function (00:08) Problem Setup (00:49) Defined Names for ranges using keyboard for Create Names From Selection: Ctrl […]

### Dueling Excel 68

March 9, 2016

Count Dates in Column That Match Year and Month Criteria DESCRIPTION See Mr Excel and excelisfun Count Dates in Column That Match Year and Month Criteria with the functions: DATEVALUE, EOMONTH, LOOKUP, SUM, TEXT, COUNTIFS […]

### EDATE & EOMONTH Functions

December 20, 2015

WORKBOOKS

### Dueling Excel 033

July 22, 2015

First Monday For Reporting Period DESCRIPTION See Mr Excel and excelisfun show three formulas for finding first Monday of reporting period: If 1st day of month is Monday, then that day, otherwise the last Monday […]

### Excel Magic Trick 1123

April 23, 2015

DESCRIPTION See how to… Create a formula To Create A List of Dates For Month. Change the start date and the list updates. See the functions, EOMONTH, DAY, IF, ROWS. WORKBOOKS

### Excel Magic Trick 1104

March 2, 2015

DESCRIPTION See how to add unit numbers with AND and OR Criteria where the criteria are given as years and months but date column contains serial number dates. See how to use SUMIFS function to […]