Try this:
A1: =TODAY()+CHOOSE(WEEKDAY(TODAY(),2),4,3,2,1,0,6,5)


Is that what you're looking for?

***********
Regards,
Ron


"Richard" wrote:

Hi Guys,

Anyone can help me?
Example, today is 28/11/2005.
I would like make a template with formula on A1. On the A1 always show the
Friday when this template is open.
Example the template open on 28/11/2005, therefore on A1 will be show
2/12/2005. If the template open on 2/12/2005, it is still show 2/12/2005, but
when the worksheet open on 3/12/2005, it will show the 9/12/2005. Anyone can
help me please? Many thanks for your help guys.

Best regards

Richard Kennedy
Many