=A1+6-WEEKDAY(A1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"EdStevens" wrote in message
oups.com...
Looping through a series of cells with dates, need to compute from the
given date the date of the following Friday. If the given date *is*
Friday, I need that date returned, not the date of the Friday of the
following week.

Thanks.