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)
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)
Sorry, I missed seeing that difference.
Apparently, THAT was the problem with the formula. It's working now!
Thank you so much!
