1st question... If A1 is "Thursday". It shoud stay the same.
2nd question... If it is "Friday" it should be the Thursday that has
passed. The next one is too far away.

"T. Valko" wrote:

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?