|In an IF() statement, processing STOPS when it hits a True value,|
now since your first statements is
IF F2 > 01/01/2000 and IF F2 < 01/01/2000
One of those two statements should return True, so processing Stops
UNLESS you happen to use the Date 1/1/2000 in which case, since your using JUST the Greater Than and Less Than symbols both statements return FALSE and you continue to the next clause.
I would suggest Two changes, turn either
the Greater Than symbol >
or the Less Than symbol <
into a Greater Than or Equal to symbol >=
or a Less Than or Equal symbol <=
Also change your Date from the value 1/1/2000,
which in the formula evaluates out to the Number 0.005,
by using the DATE function, like DATE(2000,1,1)
this will avoid any ambiguity in the formula.
So something like: