Excel: Farmers Market

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: Those new settings in NETWORKDAYS.INTL don't help me. Our business is only open Monday, Wednesday, Friday, and Saturday.

Strategy: There is an alternate way to specify the third argument. Instead of specifying 1-7 or 11-17, you can specify a 7-digit text string comprised of 1's and 0's. The first character in the text is Monday. The seventh character is Sunday. Remember the name of this argument is [weekend]. Thus, a 1 indicates that the business is closed and a 0 indicates that the business is open.

  1. Use the "œ0010001" argument for Barber Shops.