In another cell I can then multiply that result with 075 to reach the number of days the retail store has to sell the product. Then the 1 represents the first day of that month. As you can see the first formula counts the total number of working days where the holidays are not excluded.
The value in each of the cells should appear as a date instead of a.
The formula used in here are NETWORKDAYS B2C2 and NETWORKDAYS B4C4B7B11. Select File Options. If you open the workbook at a later date the value used for TODAY will update and you will get a new result. MINUS value 1 value 2.