Hi José,
It is all well explained in the link I gave you:
http://www.cpearson.com/excel/weeknum.htm
Look at this example:
<For example, if you set the return type of WEEKNUM to 2, indicating that weeks begin on Monday, and the year is 2001, which
begins on a Monday, week 1 will have 7 days. But for the year 2006, which begins on a Sunday, week 1 will have only 1 day. For
example, if A1 contains the date 2000-Jan-9, a Sunday, the function
=WEEKNUM(A1,2)
will return 2, as 2000-Jan-9 is the last day of the second week of 2000. Since the 2 in the formula indicates that weeks begin on
Monday, week 2 is computed as Monday, 2000-Jan-3 through Sunday, 2000-Jan-9. If we change the formula to
=WEEKNUM(A1,1)
it will return 3, since the 1 in the formula indicates that weeks begin on Sunday, and week 3 is computed as Sunday, 2000-Jan-9,
through Saturday, 2000-Jan-15.>
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Salut Niek
|
| My answer is late ; I was out. Here, a week begins on monday.
|
| I type 16-10-2006 in a cell. Then in another one ="Semaine " &NO.SEMAINE(G2;1)
|
| I get Semaine 42. This is correct. But, if instead of G2,1 I type G2,2 I get
| Semaine 43.
|
| This is what you can read in the NO.SEMAINE help :
| 1 le dimanche ; les jours de la semaine sont numérotés de 1 à 7.
| 2 le lundi ; les jours de la semaine sont numérotés de 1 à 7.
|
| I am confused.
|
| Regards
| José
|
|
| "Niek Otten" wrote:
|
| > Hi José,
| >
| > Week 42? for which date?
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | Good morning Niek
| > | Tks for your prompt reply. What is said below suits the Excel help :
| > | =WEEKNUM(A1,2)
| > |
| > | will return 2, as 2000-Jan-9 is the last day of the second week of 2000.
| > | Since the 2 in the formula indicates that weeks begin on Monday, week 2 is
| > | computed as Monday, 2000-Jan-3 through Sunday, 2000-Jan-9.
| > |
| > | But it does not work for me. For getting a correct week number, I must use 1
| > | instead of 2. For getting Week 42, I must write (french version)
| > | =NO.SEMAINE(A1,1)
| > |
| > | Tks again
| > | José
| > |
| > | "Niek Otten" wrote:
| > |
| > | > It depends on your definition of week number.
| > | >
| > | > See
| > | >
| > | >
http://www.cpearson.com/excel/weeknum.htm
| > | >
| > | > --
| > | > Kind regards,
| > | >
| > | > Niek Otten
| > | > Microsoft MVP - Excel
| > | >
| > | >
| > | > | Gentlemen
| > | > | The argument type in french NO.SEMAINE help says to use 1, if the week
| > | > | begins a sunday and 2, if it begins a monday.
| > | > | I am obliged to use the reverse here to obtain a correct week number. I have
| > | > | probably missed something.
| > | > |
| > | > | Regards
| > | > | José
| > | > |
| > | > | ----------------
| > | > | This post is a suggestion for Microsoft, and Microsoft responds to the
| > | > | suggestions with the most votes. To vote for this suggestion, click the "I
| > | > | Agree" button in the message pane. If you do not see the button, follow this
| > | > | link to open the suggestion in the Microsoft Web-based Newsreader and then
| > | > | click "I Agree" in the message pane.
| > | > |
| > | > |
| > | >
| >
http://www.microsoft.com/office/com...b-d7336e009fc6&dg=microsoft.public.excel.misc
| > | >
| > | >
| > | >
| >
| >
| >
