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/comm...lic.excel.misc

It depends on your definition of week number.

See

http://www.cpearson.com/excel/weeknum.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"José" wrote in message ...
| 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/comm...lic.excel.misc

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


"José" wrote in message ...
| 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/comm...lic.excel.misc

Hi José,

Week 42? for which date?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"José" wrote in message ...
| 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
|
|
| "José" wrote in message ...
| | 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/comm...lic.excel.misc
|
|
|

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

"José" wrote in message ...
| 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
|
|
| "José" wrote in message ...
| | 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/comm...lic.excel.misc
|
|
|

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




"José" wrote in message ...
| 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
|
| "José" wrote in message ...
| | 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
| |
| |
| | "José" wrote in message ...
| | | 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/comm...lic.excel.misc
| |
| |
| |
|
|
|