The first part of formula looks fishy. You ask it to check if the cell equals
the text string "0-Jan-00". I think what's actually happening is the cell is
formatted as a date, and it has a value of 0. In which case, the cell
actually has a value, not text. (as an example, try typing in a cell
(=J2="0-Jan-00"). You'll see that it says "FALSE").

Try this:
=IF(J2=0,"To be advised",WORKDAY(J2,1,NWD))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Connie Martin" wrote:

I am trying to adapt a formula in I2 from another spreadsheet that works
well, but won't in mine. I've traced the error, but I would need help to
understand the help it gives! My formula is this: =IF(J2="0-Jan-00","To be
advised",WORKDAY(J2,1,NWD)). I have a worksheet in the same workbook with a
list of non-workdays, and defined the column of dates with the name "NWD".
What I expect the formula to do is this: If J2 is Feb. 4, it would give Feb.
5 in cell I2 because Feb. 5 is NOT a non-workday in NWD. But if J2 is Feb.
5, and Feb. 6 and 7 are non-workdays in NWD, then it would give Feb. 8. I
don't know how this formula works in the other spreadsheet, but it does.
Can anyone help? Connie