Here is one of many ways:
=CHOOSE(WEEKDAY(TODAY()),TODAY()+5,TODAY()+4,TODAY()+3,TODAY()+2,TODAY()+1,TODAY(),TODAY()+7,TODAY()+6)
Note that if today is a Friday, this returns Today's date. If you want the next Friday, add 8 to the Argument ,TODAY(),(3rd from last)
This message was edited by lenze on 2002-09-04 13:08