number of working days in Excel

Q17. In Excel, how can I find the number of working days between 2 dates given a holidays list?

For example, I want to find the number of working days in Jul-Sep 2017 given that 01st Aug (National Day) and 18th Sep (Bettagsmontag) are holidays so that I can calculate the wages for the month for employees that are paid on hourly basis.

(assuming Saturday and Sunday are holidays every week).

To do it in Excel, here is the answer:

a) Enter the formula =NETWORKDAYS(AG2,AG3,AG5:AG6) where AG2 and AG3 contain the start and end dates of the period and "AG5:AG6" corresponds to the range that has the holidays list for the period.

excel number of working days

 

You can find similar Excel Questions and Answer hereunder

1) Concatenate number with text but keeping in number format in Excel

2) How can I get row count of filtered data?

3) How do I calculate monthly payment given Loan amount, Rate of Interest and period?

4) I have a big Table spanning across pages when printed - how do I get Excel to print titles in all pages?

5) How can I identify all cells with Conditional Formatting in my WorkSheet?

6) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?

7) How do I get the rank of a number in a list of numbers?

8) How can I hide Formula Bar and Headings using VBA?

9) I have test scores for my student population. In Excel, how can I determine confidence interval for my Population Mean?

10) How can I find the least common multiple using Excel?

11) How can I convert Column numbers into Column names for use in range definition?

12) How can I get the day number of the year for a date - for example 5 for Jan 5, 33 for Feb 2?

13) How do I get the 2nd highest number in a range of numbers?

14) How can I check if a file exists in a folder using VBA?

15) How can I generate random numbers between 2 limits?