From: Connie Martin on 13 Jan 2010 15:59 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 From: Connie Martin on 13 Jan 2010 16:19 Never mind this post. I was getting impatient. Please refer to post three down from this one "Need help with formula". Thank you. Connie "Connie Martin" wrote: > 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  |  Pages: 1 Prev: How do I add the formula bar?Next: Determine if 2 cells share a common word