Need to get the text FALSE when dealing with a zero value cell using the OR function

Hi,

I created a really complex sheet for my work and figured out all sorts of formulas. But I am now stumped.

A week ago, I did a formula that would come back as either TRUE or FALSE if a date fell within the week number of a sign off date that was manually entered in, as well as 6 months past it. Basically I wanted a reminder every 6 months after the person was signed off on our equipment to refresh them. And I had the reminder include the week number as well so that it would remind me for an entire week that they needed to refresh. The formula was as follows:

=OR(WEEKNUM(EDATE(Sheet1!F2,6))=WEEKNUM(Sheet2!$B$1),WEEKNUM(Sheet1!F2)=WEEKNUM(Sheet2!$B$1)) -with $B$1 being the TODAY() function. F2 being the date it was looking at to compare to the today cell.

It worked well initially. But now, it suddenly comes back TRUE for every blank cell (not truly blank apparently, checked with ISBLANK, but a cell with 0 value). I need to somehow add on to this formula a way to tell excel that if a cell contains a "0", then put in the text "FALSE". or a way to tell it that if the cell is a "0" or blank, to not do the formula. or third option, find a way to truly make the cell blank so that the equation returns a FALSE answer.

I have tried this, but it got me no where:

=IF(F2="0","FALSE",OR(WEEKNUM(EDATE(Sheet1!F2,6))=WEEKNUM(Sheet2!$B$1),WEEKNUM(Sheet1!F2)=WEEKNUM(Sheet2!$B$1)))

Thank you for all your help!

I did the ISBLANK and it came back as false to the blank cells. so im assuming it is a 0 value

Sorry for the long pause. but I needed to edit information out. You will see that I was basically putting in the same formula to do conditional formating as well. There should only be 5 dates highlighted orange and labeled True on Sheet 2.

FORUM SHEET.xlsx

Thank you again