Bit of a workaround using the NETWORKDAYS.INTL function
![]()
=IF(G13="",1,NETWORKDAYS.INTL(G13,H13,17,Holidays)+NETWORKDAYS.INTL(G13,H13,11,Holidays)-NETWORKDAYS.INTL(G13,H13,1,Holidays))
Bit of a workaround using the NETWORKDAYS.INTL function
![]()
=IF(G13="",1,NETWORKDAYS.INTL(G13,H13,17,Holidays)+NETWORKDAYS.INTL(G13,H13,11,Holidays)-NETWORKDAYS.INTL(G13,H13,1,Holidays))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks