A couple of questions:

What if the date in A1 *is* Thursday?

What if the date in A1 was for a Friday, would you want the Thursday date
that has just passed or do you want the *next* Thursday date?

--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
In this case (of course the day will change in some cases) I want to know
what is the the closest "thursday" from a specific date.

In A1 i have 10/14/08.... in B1 i have "thursday"..... In C1 i want to
know
which is the closest Thursday from A1..


The answer to this should be 10/16/08..

Is there a formula for this?