can you explain the B2<Max(A3:A99)
That simply looks for the latest date in A3:A99 and checks that the date in B2 is less than that latest date....If so, it returns TRUE so that you get a "Possible" returned.
is there a way to say B2<any A3:a99 cell?
The way to do that is to add this statement....OR(B2<A3:A99)
But this would turn your formula into an array formula and would have to confirmed with CTRL+SHIFT+ENTER keys not just the ENTER key with normal formulas....
Formula would be:
confirmed with CTRL+SHIFT+ENTER
Bookmarks