=A1+CHOOSE(WEEKDAY(A1),5,4,3,2,1,0,-1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"The Rook" wrote in message
...
Is it possible to find the date for a specific day of the week from a
given
date?
For example:
If I have the date 30-07-07 in column A and would like to report the
Friday
of the week in column B, the reuslt would be 03/08/07.

Regards