Next Known Date
 

Is there a simple function in Excel that will return the next known
date for a specific day of the week?

Regards

Stopher

Next Known Date
 

I do not know of a simple function - but I am using excel 97. However, this
will work.

=IF(VLOOKUP(B12,$B$1:$C$7,2,FALSE)WEEKDAY(B11,1), B11+(VLOOKUP(B12,$B$1:$C$7,2,FALSE)-WEEKDAY(B11,1)),B11+7+(VLOOKUP(B12,$B$1:$C$7,2,FAL SE)-WEEKDAY(B11,1)))

where the vlookup range is a table with Sunday thru Saturday in column 1 and
1 through 7 in column 2. B11 has the date in question, and B12 has the day
of the week desired.



" wrote:

Is there a simple function in Excel that will return the next known
date for a specific day of the week?

Regards

Stopher

Next Known Date
 

On 4 Jul 2006 16:42:21 -0700, wrote:

Is there a simple function in Excel that will return the next known
date for a specific day of the week?

Regards

Stopher

If the date in question is a Sunday, is the next known date the same date, or
one week later?

If it is the same date,then:

=A1+7-WEEKDAY(A1-DOW)

If it is a one week later, then:

=A1+7-MOD(WEEKDAY(A1-DOW),7)

DOW is Day Of Week with Sunday =1, Monday =2, etc.

A1 is any date, or TODAY()


--ron

Next Known Date
 

Absolutely excellent, Thankyou.

Stopher

Next Known Date
 

On 4 Jul 2006 20:26:12 -0700, "Stopher" wrote:

Absolutely excellent, Thankyou.

Stopher

You're welcome. Glad it worked for you.
--ron