### Excel Magic Trick 1312

DESCRIPTION Learn: (00:08) Problem introduction. (00:33) How to use NETWORKDAYS.INTL to count the number of working days between a start and end date. NETWORKDAYS.INTL is in Excel 2010 or later versions. (01:46) Formula to count [Read More >>>]

### Excel Magic Trick 1272

DESCRIPTION Max Value for Each Day Of The Week: AGGREGATE Function (2 Methods) Learn how to find the max value for each day of the week using the Excel 2010 or later function AGGREGATE. See [Read More >>>]

### Dueling Excel 126

DESCRIPTION SUM Daily Totals from Text Dates with Text Day Criteria See Mr Excel and excelisfun use two methods to 1. Add up daily sales from a template that is not setup properly: multiple columns [Read More >>>]

### Dueling Excel 120

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 [Read More >>>]

### Dueling Excel 69

Count Saturdays DESCRIPTION See Mr Excel and excelisfun create formulas to count Saturdays from a start date and end date. See the functions NETWORKDAYS.INTL, INDIRECT, ROW, WEEKDAY and SUMPRODUCT. See Mike Total mess up the [Read More >>>]

### Display Day Name From A Date

If you need to get the day name (Monday, Tuesday, Wednesday etc.) from a date there are several options depending on your needs. In this article we will show you a few examples on how [Read More >>>]

WORKBOOKS

WORKBOOKS

### Dueling Excel 044

Count Mondays Between 2 Dates WEEKDAY or TEXT? DESCRIPTION See Mr Excel and excelisfun count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and [Read More >>>]

### Dueling Excel 038

Weekly Report Formula or Pivot Table? DESCRIPTION See Mr Excel and excelisfun take daily transactional data and create Weekly Summary Reports using a Pivot Table (PivotTable) and a series of formulas. Learn about: 1.Formula for [Read More >>>]