Data not adjusting when date changes.

[taylorsm]

Have a production report. It has two pages, one is a Summary, the other Totals. The employees enter their information on the Totals sheet and on the Summary I can select the date from a drop down and it should show me the employees information for that day only. I recently broke it I guess. I do not know where I screwed it up at but the summary doesn't change when I change the date.

In the Date columns that looks for the matching date in my data validation box has this

=IF($AF$2="","",IF(COUNTIF(Totals!F:F,$AF$2)<ROW()-2,"",$AF$2))

I just opened an original version, one that hadn't been tampered with and was saved just for this kind of thing and it doesn't seem to work either?