The closest "specific day" to a specific date.
 

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?

The closest "specific day" to a specific date.
 

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?

The closest "specific day" to a specific date.
 

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?

The closest "specific day" to a specific date.
 

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.

--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
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?

The closest "specific day" to a specific date.
 

You got it as always!!!
Thanx again. :)
Jman

The closest "specific day" to a specific date.
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
You got it as always!!!
Thanx again. :)
Jman