I am having a problem filtering using the custom filter in Autofilter. I
want to custom filter by dates greater than - for instance 1/01/1994. I
only get the 1900 dates and not the 2000 dates.

At first this worksheet had dates in 2-digit year format, and not all of
them were recognized as numbers - some were seen as text. I inserted a
column and manually re-entered dates using a 4-digit year and the problem
continues. I've multiplied by the number 1. I've copy/paste
special\values. I've copy/paste special\values the entire worksheet to a
new workbook. Is there something inherently wrong/different about filtering
dates that I've not yet stumbled across?