Excel spilled range operator (#) allows formulas to automatically ... and your spreadsheet contains a formatted Excel table called Animals_Admitted, which shows the animals currently under your ...

NOTE: For this Filter, AND is the correct Boolean operator because you want ALL dates between (A) AND (B). If you select OR, Excel displays the entire database table because ALL the dates are ...