Networkdays - Formula showing reference needs to clear

[shiraz50]

Hi

In column BN i need the public holidays for 2023 to be excluded from the nework days . It does not allow me to copy the public holidays all the way to column 18 from the second sheet.

Formula in Column BN

=IF(ISBLANK(U5);"";IF(AND(ISNUMBER(U5)=FALSE;ISNUMBER(X5)=FALSE);"Not sent as yet";IF(AND(ISNUMBER(U5)=TRUE;ISNUMBER(X5)=TRUE);NETWORKDAYS(U5;X5;'C:\Users\502766436\AppData\Local\Box\Box Edit\Documents\4PqXdAP0U0qp503ktNccfA==\[GE Parts Logistics Tracker - WE10.xlsx]Public Holidays'!$A$5:$A$16);IF(AND(ISNUMBER(U5)=TRUE;ISNUMBER(X5)=FALSE;ISNUMBER(BM5)=TRUE);NETWORKDAYS(U5;$BL$1;'C:\Users\502766436\AppData\Local\Box\Box Edit\Documents\4PqXdAP0U0qp503ktNccfA==\[GE Parts Logistics Tracker - WE10.xlsx]Public Holidays'!$A$5:$A$18)-1))))

Even column BT has the same issue. Please help.

Formula in Column BT

=IF(ISBLANK(U6);"";IF(AND(ISNUMBER(U6)=FALSE;ISNUMBER(Y6)=FALSE);"Not sent as yet";IF(AND(ISNUMBER(U6)=TRUE;ISNUMBER(Y6)=TRUE);NETWORKDAYS(U6;Y6;'C:\Users\502766436\Documents\Spares\weekly tracker\[GE Parts Logistics Tracker - WE47 2020.xlsx]Public Holidays'!$A$5:$A$16);IF(AND(ISNUMBER(U6)=TRUE;ISNUMBER(Y6)=FALSE;ISNUMBER(BS6)=TRUE);NETWORKDAYS(U6;$BL$1;'C:\Users\502766436\Documents\Spares\weekly tracker\[GE Parts Logistics Tracker - WE47 2020.xlsx]Public Holidays'!$A$5:$A$18)-1))))

 

[shiraz50]

@shiraz50 in future please do mark mark a post as the solution when it does not contain one. Thanks

Will do Fluff .