Forum Discussion
Hello Dears
I need help please to fix below formula. IF(AE2="",TODAY()-D2,NETWORKDAYS.INTL(D2,AE2,1,$AJ$2:$AJ$15)-1-MOD(D2,1)+MOD(AE2,1)) AE is the close date D2 is the receive date. when AE (close ...
=NETWORKDAYS.INTL(D2,IF(AE2="",TODAY(),AE2),1,$AJ$2:$AJ$15)-1-MOD(D2,1)+MOD(IF(AE2="",TODAY(),AE2),1)