the date always friday

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Another way a bit shorter

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

--
Regards,

Peo Sjoblom

(No private emails please)
 
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
 
Back
Top