Problem with NETWORKDAY.INTL Function

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
9,636
Office Version
2019
Platform
Windows
When I replied earlier, I misread the last line of your post as 'half day off' instead of '1 or 2 days off'.

In hindsight, I think that this is correct

=WORKDAY($E$8+1,$F$19/$B$23,IF($D$16:$D$48<>"",$D$16:$D$48+1,))
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

masud8956

Board Regular
Joined
Oct 22, 2016
Messages
156
Office Version
2016, 2011, 2007
Platform
Windows
Thank you. Works fine!!
 

Watch MrExcel Video

Forum statistics

Threads
1,099,737
Messages
5,470,446
Members
406,700
Latest member
Mark Rob

This Week's Hot Topics

Top