|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 28th, 2005, 01:58 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
the date always friday
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 
|
|
#2
November 28th, 2005, 02:11 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
the date always friday
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
|
|
#3
November 28th, 2005, 03:28 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
the date always friday
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
|
|
#4
November 28th, 2005, 06:15 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
the date always friday
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Default Friday Date | face | General Discussion | 5 | October 28th, 2005 12:27 PM |
| Outlook today should show tasks based on Start Date, not due date | Rose | General Discussion | 10 | October 9th, 2005 03:14 AM |
| Date Range and Average F/X Rate | David | General Discussion | 0 | June 23rd, 2005 02:26 PM |
| QDE (Quick Date Entry) | Norman Harker | General Discussion | 3 | September 3rd, 2004 08:00 AM |
| more dates!!! | brigid | Running & Setting Up Queries | 6 | May 26th, 2004 10:59 AM |
Linear Mode
