Data Sorting

[NewExcelUser]

Hi Ladies and Gents!

In this file, I have to worksheets, "A" and "B". Worksheet A is for input purposes, and worksheet "B" is for sorting the data.

I have the sorting set up so that the information does not appear until the day before the new month based upon the date and it removes the entries as the days pass of the anniversaries ... and it works fine..... until it hits row 22... The data appears and I cannot figure out why... Can anyone help? Also, ultimately I would like for all of the data to be displayed (if the day is before the anniversary day). It just so happens that the data does not appear until the day prior to the new month, but I would like to have the information appear if it were in the middle of the month prior.......

I have attached a worksheet to help illustrate...

By the way, a million thanks to all who helped me create this worksheet!

[NewExcelUser]

Nothing on this yet eh?

It's strange - everything seems correct.... There is nothing that I can see that would make the data just start appearing after line 22.... I will investigate this more tonight, trying different formulas and different variations of the current formula.