Nested referenced date addition formula

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?
- Willy Lau
  Iron Contributor
  Feb 13, 2018
  The first step you should check A61 to see if it return the actual serial number for 27 Feb 2018.
  - Willy Lau
    Iron Contributor
    Feb 13, 2018
    the next step is to break the formula piece by piece without using formatting if possible.
Immortalis
Brass Contributor
Feb 13, 2018
In theory, the formula should work however, Excel doesn't seem to like it for some reason.

So, whatever the reason is, it does not work. Therein lies the problem and I can't seem to find the solution or any way of creating a formula that will work :(
- Willy Lau
  Iron Contributor
  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)
  - Immortalis
    Brass Contributor
    Feb 13, 2018
    Sorry, I missed seeing that difference.
    
    Apparently, THAT was the problem with the formula. It's working now!
    
    Thank you so much!

Forum Discussion

Nested referenced date addition formula

Resources