J
James
I have created a spreadsheet that uses the NETWORKDAYS function and all
formulas now do not work.
I had added the Analysis ToolPak add-in to access the function and
everything was working perfectly until I opened up my spreadsheet and a large
number of cells had #NAME? in the cells.
It appears that there is a function within my formulas that don't now work.
The formulas I am using are:
(IF(TODAY()<$H7,NETWORKDAYS($H7,$I7,'Statutory Bank
Holidays'!$B$4:$H$18),NETWORKDAYS(TODAY(),$I7,'Statutory Bank
Holidays'!$B$4:$H$18))
=IF(K5<TODAY(),K8*5/NETWORKDAYS(TODAY(),K6),K8*5/NETWORKDAYS(K5,K6))
Can anyone help me to fix this problem?
formulas now do not work.
I had added the Analysis ToolPak add-in to access the function and
everything was working perfectly until I opened up my spreadsheet and a large
number of cells had #NAME? in the cells.
It appears that there is a function within my formulas that don't now work.
The formulas I am using are:
(IF(TODAY()<$H7,NETWORKDAYS($H7,$I7,'Statutory Bank
Holidays'!$B$4:$H$18),NETWORKDAYS(TODAY(),$I7,'Statutory Bank
Holidays'!$B$4:$H$18))
=IF(K5<TODAY(),K8*5/NETWORKDAYS(TODAY(),K6),K8*5/NETWORKDAYS(K5,K6))
Can anyone help me to fix this problem?