Did not work! Part of your formula has me confused =NETWORKDAYS(LOOKUP(2,1/(ISNUMBER(J12:EJ12)*(J$6:EJ$12<>"")),J12:EJ12),EW12) should the J$6:EJ$12 be J$12:EJ$12? I tried changing the 6 to a 12 but still did not work.
Did not work! Part of your formula has me confused =NETWORKDAYS(LOOKUP(2,1/(ISNUMBER(J12:EJ12)*(J$6:EJ$12<>"")),J12:EJ12),EW12) should the J$6:EJ$12 be J$12:EJ$12? I tried changing the 6 to a 12 but still did not work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks