Excel: Filtering or updating the table screws up this formula for some reason

I have a couple of excel sheets that I am using this formula in. At the start of every month, I delete all but the first record of the table and paste in the new month's data. This however screws up the formula and it ends up with completely different cell references. Filtering the data seems to do the same thing. The forumula I'm using is: =IF(B2="","",IF(ISNA('Print ref'!B2),NA(),'Print ref'!B2-TODAY()&" Days remaining"))

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of June 04, 2017.

For more resources for Microsoft Excel