I've read, read, and read about the WORKDAY function (Excel Help and online)
and cannot find a solution as to why my formula is giving me #NUM!. I read
the reasons why, but cannot find any errors. All columns with dates are
formated to 'date'. Analysis Toolpak is checked in Tools/Add-ins. The
formula in I3 is this: =WORKDAY(J3,1,NWD)
€¢ J3 is the date 16-Feb-10, formatted as date (format cells, etc.)
€¢ J3's date comes from a VLOOKUP function, from a column that is formatted
as a date
€¢ NWD (meaning "non-workdays") is a named range in another worksheet of the
same workbook, and is formatted as a date (format cells, etc.).
€¢ NWD was inserted into the formula by Insert/Name/Paste
€¢ With this formula in I3 it should give 17-Feb-10. Very simple, this one.
But it gives me #NUM!.
Can anyone shed some light on this? It's getting very frustrating! I would
be so very, very grateful if you could. Thank you. Connie