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?

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?

I think I understand what you want, try:
=IF(C1<"",L1+WORKDAY(M2,5),"")


"Vegas Sara" wrote:

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?

Hi,

had you looked in help you would have read this:-

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

Tools|Addins and check the analysis toolpak then try this formula

=IF(C1<"",WORKDAY(L1,5),"")

Mike

"Vegas Sara" wrote:

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?

Thank you everyone for your help!

"Vegas Sara" wrote:

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?