Using Data Validation I have a combo box with a list =payperiods (which are
1/9/04
1/23/04
2/6/04
2/20/04
3/5/04...
5/28/04
6/11/04...
12/24/04

Here in the May/June time of the year, I'd like to have when the employee
clicks
on the DownArrow of the Combo box instead of seeing the first 8 entries
being 1/9/04, 1/23/04 etc I'd like to based on =now() or today() have the
listing "start-with" the first date meeting my =now() criteria. Can this be
done?

Thanks in advance,