Hi David:

This is pretty generic, but it works.

1. Go through the calendar and write down all the Thursday’s that meet
your criteria.

2. Place them in order and in a column somewhere off the visible area
of the work sheet such as column AA.

=IF($A$1<=AA1,AA1,"")

3. Place this formula in AB1 and copy it down to match the range of
dates in the AA column, cell $A$1 is whatever cell you keep today’s
date in.

=MIN(AB1:AB27)

4. Place this formula in whatever cell you choose to see the results
and format that cell to date.



Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=482360