You say..
Some rows are blank.
Each row contains the date

hummmm...
We aren't off to a good start..

So which is it?



"Steve" wrote:

I have a list of information in contained in A1:R500. Some rows are blank.
Each row contains the date the job was scheduled. Cell T1 contains the
current date. What I need to do is examine the data and extract only the
rows that fall within a 14 day period prior to this date. Then create a drop
down list based on the result.
Thanks for the help,
Steve