Forum Discussion

Brass Contributor

Feb 13, 2018

Solved

Nested referenced date addition formula

Hello everyone. I've a new problem I can't seem to find answers for and I'm hoping someone can help. Cell A61 has a formula which returns the date "Tue 02-27" (2018 although the year not shown)...

Formulas & Functions

Need Help

Willy Lau
Feb 13, 2018
There are many reasons to have that result.

You may use array formula in a function that it does not support. or using relative reference in correctly, or miss to handle some cases in if statement.

Your A61 is a generated value. There are many reasons. Also, you did not check the formula that I pointed out that is is not correct.

Day(A1)+2 <> Day(A1 + 2)

Willy Lau

Iron Contributor

Feb 13, 2018

Can you double check the formula? Is it really
=IF((DAY(A61)+2)="1",(A61+2),"Not")
or
you wrote it to
=IF((DAY(A61)+2)="1",DAY(A61+2),"Not")

Immortalis
Brass Contributor
Feb 13, 2018
My formula returns the whole NEW date, your version would just return the new DAY.
- Willy Lau
  Iron Contributor
  Feb 13, 2018
  the correct formula is
  
  =IF(DAY(A61+2)=1,(A61+2),"Not")
  
  I can't assume the formula is correct to find the problem
  - Immortalis
    Brass Contributor
    Feb 13, 2018
    From your formula, =IF(DAY(A61+2)=1,(A61+2),"Not") ...
    
    =DAY(A61+2)
    
    will return a value of 1
    
    but
    
    =IF(DAY(A61+2)=1,(A61+2),"Not")
    
    returns "Not".
    
    As far as I can figure, the issues lies with having a formula inside the DAY() function.
    
    Is there any other way of accomplishing my goal?