Hi folks...
I am using the following formula to perform a basic calculation, but I am getting a formula error message.
=workday(D7,D11,'0 DO NOT EDIT 2'!A3:A97)
D7 remains blank until needed.
I have this same calculation on 100 different client data tabs, and each has this error.
I only use it one to begin my timeline. Once that is complete, it is wiped and I start again.
Error messages:
There is a problem with a number used in this formula.
The next evaluation will result in an error.
I am thinking the error is only because it D7 is empty, correct?
I am using the following formula to perform a basic calculation, but I am getting a formula error message.
=workday(D7,D11,'0 DO NOT EDIT 2'!A3:A97)
D7 remains blank until needed.
I have this same calculation on 100 different client data tabs, and each has this error.
I only use it one to begin my timeline. Once that is complete, it is wiped and I start again.
Error messages:
There is a problem with a number used in this formula.
The next evaluation will result in an error.
I am thinking the error is only because it D7 is empty, correct?