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?