The closest "specific day" to a specific date.

J

Jman

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?
 
T

T. Valko

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?
 
J

Jman

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

T. Valko

Ok, I'm not certain I understand what you want.

Maybe this:

A1 = some date
B1 = some weekday like Thursday

=MATCH(LEFT(B1,2),{"Mo","Tu","We","Th","Fr","Sa","Su"},0)-WEEKDAY(A1,2)+A1

That will return the date of the weekday in cell B1 based on the week date
in cell A1.
 
Top