Michele317
New Member
- Joined
- Apr 29, 2024
- Messages
- 20
- Office Version
- 365
- Platform
- Windows
Hello
I'm having problems with the NETWORKDAYS() function.
In a workbook, I have a list of dates and I want to calculate how many Monday, Tuesday, Wednesday and Thursday there are in that list.
I do the follwing formula =NETWORKDAYS(B3;B32;"0000111";Settings!E10:E23) (where B3=1 April 2024 and B32=30 April 2024) and seems to work. The result I have it's 16, since I have also 2 holidays, which are 1 April 2024 and 25 April 2024.
I do the same formula in another workbook and I get 17 instead of 16. How is that possible?
I tried to count how many fridays there are in the list (which is another thing I need) and it worked.
I also iterate the process modifying the range of dates and it turned out there is a problem with 28 April 2024, which is a Sunday but it is taken as a workday
Thank you in advance
I'm having problems with the NETWORKDAYS() function.
In a workbook, I have a list of dates and I want to calculate how many Monday, Tuesday, Wednesday and Thursday there are in that list.
I do the follwing formula =NETWORKDAYS(B3;B32;"0000111";Settings!E10:E23) (where B3=1 April 2024 and B32=30 April 2024) and seems to work. The result I have it's 16, since I have also 2 holidays, which are 1 April 2024 and 25 April 2024.
I do the same formula in another workbook and I get 17 instead of 16. How is that possible?
I tried to count how many fridays there are in the list (which is another thing I need) and it worked.
I also iterate the process modifying the range of dates and it turned out there is a problem with 28 April 2024, which is a Sunday but it is taken as a workday
Thank you in advance