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