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

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

Hi Ron and Peo,

Both of you, I would like to say many thanks both of your answer. Your
answer help my job finished quicker. Merry Christmas and Happy New Year to
both of you.

Best Regards

Richard Kennedy

"Ron Coderre" wrote:

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

Another way a bit shorter

=INT(TODAY()/7)*7+6

--
Regards,

Peo Sjoblom

(No private emails please)


"Richard" wrote in message
...
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