#NAME? error

Question

I am trying to create a formula that will let me display continuing dates for a specific name.  I have a spreadsheet of letters I am trying to keep track of.  Each letter is designated with a name "Client" "Employer", etc.  Each letter has different due dates, "Client" is 2 days due to worker from received date, 3 days due to manager from received date, "Employer" is 3 days due to worker from received date and 5 days due to manager from received date, etc.  I am trying to create a formula stating IF it is a "Client" letter, THEN 2 days due from received date is "x date", 3 days due to manager is "x date".  I am currently trying to use the IF/THEN with the WORKDAY (excluding weekends/holidays) formula to try and calculate the continuing dates.  I don't even know if this formula is possible but I thought I would give it a shot since what I am trying isn't working.

Answer 1

I am assuming CTS is a text string in D2

H2 has a date of June 20, 2018

I2 has Formula  =IF(D2="CTS",WORKDAY(H2,2))

That returns June 22, 2018 into I2

Gord

Answer 2

I tried the "CTS"    =IF(D2="CTS",(WORKDAY,H2,2))

It is now giving me "We found a problem with this formula.  Try clicking Insert Function on the Formulas tab....."

I did that and it changed it to =IF(D2="CTS","WORKDAY,H2,2") which made the cell say WORKDAY,H2,2 which is not correct.  If H2 is my received date, let's say 6/20/2018, then if I find the correct formula, I2 should say 06/22/2018, using the CTS (cell D2) due dates.

I thank you so much for helping me, as I said, I have no clue what I am doing.  Just fumbling through...

Answer 3

If CTS is a named range then you should not get an error.

If CTS is a text value then you must enclose in double quotes "CTS"

Gord

Answer 4

This is the formula I am using.   I am teaching myself as I go. Google is what I've been using so far so the formula I am using may be totally incorrect for what i'm trying to do. 

=IF(D2=CTS,WORKDAY(I2,2))

Basically, D2 is the letter name, CTS.  H2 is the date recieved and I2 needs to be 2 days from the received date.   So I am trying to create the formula that states if the letter is a CTS letter then I2 needs to be 2 days from H2, date received.

Answer 5

Here are a few causes of #NAME? error

• A formula refers to a name (name: A word or string of characters in Excel that represents a cell, range of cells, formula, or constant value.) that does not exist.
• A formula refers to a name that is not spelled correctly.
• The name of a function that is used in a formula is not spelled correctly.
• You may have entered text in a formula without enclosing it in double quotation marks.
• A colon (:) was omitted in a range reference.
• A reference to another sheet is not enclosed in single quotation marks (').
• A workbook that you open calls a user-defined function (UDF) that is not available on your computer.

Perhaps you could post the formula which returns the error.

Gord