How do I make my formula cells follow after a sort

chris pike
chris pike used Ask the Experts™
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...…
dynamic row not following formula
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Remove the dollar signs from the formula. Actually just remove the $ in the row reference so


One more question coming

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial