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.