Forum Discussion
Nested referenced date addition formula
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)
=IF((DAY(A61)+2)="1",(A61+2),"Not")
or
you wrote it to
=IF((DAY(A61)+2)="1",DAY(A61+2),"Not")
My formula returns the whole NEW date, your version would just return the new DAY.
the correct formula is
=IF(DAY(A61+2)=1,(A61+2),"Not")
I can't assume the formula is correct to find the problem
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 :(
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)
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?
The first step you should check A61 to see if it return the actual serial number for 27 Feb 2018.
