Hi Experts,
I have a formula in a cell in a table but when I sort the formula is looking back at the previous cells still.
The cells d23 and m23 stay d and m even after the sort.
=DATEDIF($D$23,$M$23,"m") it will stay in the correct column of course but will not follow the new row position.
This clip is after a sort by date...…
One more question coming