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

[mikemck]

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

 

[mikemck]

LOL...That part of the formula is obsolete. I forget why I had that in there, honestly. B2 is just a due date.

Much less messy now that I have taken that and the sheet reference out.

Thank you.

I surely wish I had co-workers who were good at Excel and I could bounce around ideas and such with. This is great for me.

 

[FDibbins]

Bounce away any time you like. We have some really awesome members here you think outside the box