View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Nesting workday and if

I get #Name?

Look in Excel help on the WORKDAY function. It'll tell you what to do when
you get #NAME?.

--
Biff
Microsoft Excel MVP


"Vegas Sara" wrote in message
...
I want to write the formula for if C1<"" add 5 workdays to L1. When I use
=WORKDAY(M2, 5) I get #Name? What am I doing wrong with this part of the
formula and would the if be nested inside workday or vice versa?