Hi Guys .
I intially had the formula working without network days ( Column E) .In (column F) i needed to get the calculation to be done in networkdays. I managed to get the networkdays formula working for the first set of dates(Column A & B) . I need help in getting a statement that says if column A&B have no date value than look at Networkdays within( Column E & A ) and if not date value then state as " Not sent as yet"
=IFERROR(NETWORKDAYS(A3;B3;I4:I15);IF(ISNUMBER(C3);(C3);NETWORKDAYS(C3;$BK$1;I4:I15)))
Please help me
Bookmarks