Any of these should work for you:
=TODAY()-WEEKDAY(TODAY(),1)+6

=TODAY()-WEEKDAY(TODAY()-6)+7

=TODAY()+6-MOD(WEEKDAY(TODAY())+7,7) < -- Note: if today is Friday, it
shows today's date

=TODAY()+7-MOD(WEEKDAY(TODAY())+1,7) < -- Note: if today is Friday, it
shows today's date


Hope that helps,
Ryan--

--
RyGuy


"Daniel Bonallack" wrote:

Excel 2002
I would like a formula that returns the date of the following Friday.

So if today is 11/14/2007 (american version of date), then it would return
11/16/2007

If today is a Friday, then it should return the next Friday.

Thanks in advance!
regards
Daniel