looking up values

[atdorsey]

Hey guys, Im having some difficulty figuring out a formula. What i have is column of names and each name coresponds to a date when they have to take a test. Then next to the date i have calculated the days until they have to take it. What i want to do is have a cell show the names of all the people that have to take the test in the next 10 days. i have attached a spreadsheet that shows the basic layout. the actual worksheet has many more names and dates. Any suggestions.

Thanks

[NBVC]

Try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER... you will see { } brackets appear around the formula... then copy down as far as you want...

Note: After you adjust ranges for your actual data, you have to reconfirm with the CSE keys.

Also note: That I assumed you want today's date included... if not... delete the = from the two >=Today() portions of the formula

[atdorsey]

Thanks for the reply. I Tried the formula and it worked wonderfully. Thanks so much.