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.

Weekend string values are seven characters long and each character in the string represents a day of the week, starting with Monday.
1 represents a non-workday and 0 represents a workday. Only the characters 1 and 0 are permitted in the string.
Using 1111111 will always return 0.
For example, 0000011 would result in a weekend that is Saturday and Sunday.

1 = Don’t Include in count.
1 = weekend.
0 = Include in count.
0 = workday.
in the weekend argument: TRUE = 1 = “Yes, it is a weekend”

WORKBOOKS







Related Articles

Excel Is Fun

Excel Magic Trick 1106

DESCRIPTION See how to add 3-D gradient conditional formatting to a row in a data set using the AND function to match student name and academic quarter. WORKBOOKS

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

Excel Is Fun

Excel Magic Trick 1086

DESCRIPTION 3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch & Merged Cell Trouble See how to:  (00:11 min) Create formula to lookup a value from a table with three criteria: INDEX and MATCH and [Read More >>>]

Be the first to comment

Leave a Reply