Excel Is Fun

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 Is Fun

Highline Excel 2013 Class Video 40

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

Dueling Excel

Dueling Excel 138

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

Excel Is Fun

Excel Magic Trick 1126

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 Is Fun

Excel Magic Trick 1125

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

Excel Is Fun

Excel Magic Trick 1124

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