Thread: #NUM!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Connie Martin Connie Martin is offline
external usenet poster
 
Posts: 251
Default #NUM!

This is exhausting. I've surfed and surfed for answers. None! I have a
previous post, just two or three down from this one ("Need help with
formula), but I can't get an answer. I have simplified the formula to
simply: =WORKDAY(J3,1,NWD). NWD is a defined name for a column of
non-workday dates. The date in J3 is Feb-01-10. This formula should give
Feb-02-10, but it's giving #NUM!. What gives? Connie