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"))
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"))