ColA ColB
1/2/2003 ABC
1/3/2003 EEE
1/4/2003 EEE
2/5/2003 EEE
2/6/2003 ABC
2/7/2003 EEE
2/8/2003 EEE
3/10/2003 EEE
3/11/2003 EEE
3/12/2003 ABC
3/13/2003 EEE
3/14/2003 EEE
4/25/2003 ABC
4/26/2003 EEE
4/27/2003 EEE
4/28/2003 EEE
5/2/2003 ABC

If today is 5/2/2003, how the formulas or macros can be
searched the date of ABC in last month
I want the result will be

ColA ColB
4/25/2003 ABC
5/2/2003 ABC

Thanks,