If, Lookup
 

Formula #1 = {=(IF(full_date=($B5),"Yes","No"))}


Formula #2 = {=(IF(full_date=($B5+1),"Yes","No"))}

full_date represents a Vertical table of Dates.

Formula searches full_date and sees if it matches $B5 (also a date), returns
"yes" of there is a match and "No" if there is no match.

Formula # works correctly

Formula #2 is in the next cell (next to Formula #1), It performs the same
search function, except it is looking for the day after $B5 (which is $B5+1).
It determines that there is a "true" match, but for some reason the formula
returns a "No", as if there was no match.

Does anyone understand what is going on?

Thanks