Requirement: A formula that will generate a count of the workdays (Monday - Friday) without holidays for any given month of any year.
This generates my count of working days for the month, "holidays" references a list user created of Holidays scheduled closed in the office.
Once user generated a count of days in each month user was able to vlookup this for my number to divide by.
Full formula below:
Vlookup references the results from the first formula.
Obtained from the OzGrid Help Forum.
Solution provided by Johnnyv015.
|How to COUNTIF using input cell as range depth|
|How to use COUNT|
|How to use SUMPRODUCT and COUNT question for unique associations|
|How to use COUNTIF to see if a customer is a repeat customer|
|How to work with COUNTIF with multiple criteria|
|How to use Index/Countif based on multiple factors including range|
|How to count the frequency of a specific number on a specific day|
|How to count non blanks 5 years from the last non blank date|