### Excel Magic Trick 1312

August 10, 2017

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 […]

### Highline Excel 2013 Class Video 40

June 16, 2017

DESCRIPTION Topics in this video: 1. Built-in Conditional Formatting. Conditional Formatting to cells: A logical test that comes out TRUE or FALSE. TRUE = get Formatting. FALSE = Not get Formatting. 2. Highlight Cell Rules: […]

### Dueling Excel 138

April 19, 2017

DESCRIPTION NETWORKDAYS.INTL Amazing New “Any Weekend” Argument Learn about amazing new feature in the NETWORKDAYS.INTL function for counting workdays that will accommodate any weekend scenario. See counting workdays and Conditional Formatting for weekdays or weekend. […]

### Excel Magic Trick 1266

January 30, 2017

DESCRIPTION NETWORKDAYS.INTL: Each Employee has Different Weekend Schedule? Learn how to create one formula you can copy down column that will calculate net workdays where each employee has a different weekend schedule. See how to […]

### Excel Magic Trick 1265

January 26, 2017

DESCRIPTION NETWORKDAYS.INTL Function: Calculate Net Workdays (8 examples) Learn how to use NETWORKDAYS.INTL function to calculate net working days when you are given a start and end date, what days in the week are weekends […]

### NETWORKDAYS Function

December 12, 2015

WORKBOOKS

### Excel Magic Trick 1128

April 28, 2015

DESCRIPTION See how to create an automated Accounting Ageing Accounts Receivable Reports On Multiple Sheets With Array Formula, Excel Table Feature and Formula Table Nomenclature (Structured References): (00:16) Overview of end result: Automatic Ageing Reports […]

### Excel Magic Trick 1126

April 26, 2015

DESCRIPTION See how to complete a monthly employee calendar with the text “Training” based on a start and end date, and holiday and weekend dates. See the functions: IFERROR, WORKDAY.INTL, IF, AND, and NETWORKDAYS.INTL. WORKBOOKS

### Excel Magic Trick 1125

April 25, 2015

DESCRIPTION See how to use Data Validation Custom Formula to verify that dates entered into cells are in current month and are NOT a weekend or holiday. See the AND and NETWORKDAYS.INTL functions as well […]

### Excel Magic Trick 1124

April 24, 2015

DESCRIPTION See how to Conditional Format Weekends & Holidays using the NETWORKDAYS.INTL & NOT functions. Conditionally format serial dates for weekends and holidays. Conditional Formatting. Format Conditionally. Logical Formulas. Format holidays and weekends. WORKBOOKS