Forum Discussion
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)...
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)
No, the formula was correct. Assuming the formula actually worked, my
way would take the date in A61, (Tue 02-27), working with only the day
(27), add 2 to it, (making the new date, Thu 03-01, but is still working
with only the day, (01)), then compare the day 01 to 1 and if it's
equal, woul return the new full date (Thu 01-01).