Display week number

[garce]

Anyone would have a formula to display week number. I am interested in the
ISO week number as described in Standard 8601
Under the ISO standard, a week always begins on a Monday, and ends on a
Sunday. The first week of a year is that week which contains the first
Thursday of the year, or, equivalently, contains Jan-4.

 

[Gérard Ducouret]

Hello Garce,
As far as I know, MS Project complies with the ISO Standard for the weeks
numbering.
To display weeks numbers :
Format / Timescale /
Choose a level, Units : Week, Label : 1,2 ...52

Hope this helps,

Gérard Ducouret

 

[garce]

What I am actually looking for is a new column (number/date/text/etc) in the
table view that shows start in week number (without changing the standard
date format of the actual start column). I thought I could add a column,
could customize fields and enter a formula (that will take [start] as
argument) for this. Any comments on somebody that has done this?

 

[Gérard Ducouret]

The formula could be that one, if your project is entirely scheduled on
2006:
DateDiff("ww";Dateserial(2006;1;1);[Start];2;2)
If the plan spans over several years, you'll have to improve the formula...

Gérard Ducouret

What I am actually looking for is a new column (number/date/text/etc) in the
table view that shows start in week number (without changing the standard
date format of the actual start column). I thought I could add a column,
could customize fields and enter a formula (that will take [start] as
argument) for this. Any comments on somebody that has done this?

Hello Garce,
As far as I know, MS Project complies with the ISO Standard for the weeks
numbering.
To display weeks numbers :
Format / Timescale /
Choose a level, Units : Week, Label : 1,2 ...52

Hope this helps,

Gérard Ducouret

 

[garce]

Gerard,
I created this formula for 3 year
Switch(Year([Start])=2005,DateDiff("ww",Dateserial(2005,1,1),[Start],2,2),Year([Start])=2006,DateDiff("ww",Dateserial(2006,1,1),[Start],2,2),Year([Start])=2007,DateDiff("ww",Dateserial(2007,1,1),[Start],2,2))
Yet I am having a problem of one week off in 2007...
Would you know what the problem is? I know I can probably force it ok adding
1 but would like to understand why

regards,

Gabriel

The formula could be that one, if your project is entirely scheduled on
2006:
DateDiff("ww";Dateserial(2006;1;1);[Start];2;2)
If the plan spans over several years, you'll have to improve the formula...

Gérard Ducouret

What I am actually looking for is a new column (number/date/text/etc) in the
table view that shows start in week number (without changing the standard
date format of the actual start column). I thought I could add a column,
could customize fields and enter a formula (that will take [start] as
argument) for this. Any comments on somebody that has done this?

Hello Garce,
As far as I know, MS Project complies with the ISO Standard for the weeks
numbering.
To display weeks numbers :
Format / Timescale /
Choose a level, Units : Week, Label : 1,2 ...52

Hope this helps,

Gérard Ducouret

"garce" <[email protected]> a écrit dans le message de
Anyone would have a formula to display week number. I am interested in the
ISO week number as described in Standard 8601
Under the ISO standard, a week always begins on a Monday, and ends on a
Sunday. The first week of a year is that week which contains the first
Thursday of the year, or, equivalently, contains Jan-4.

 

[garce]

All,
I found the right formula for this: Datepart("ww",[Start],2,2)
It works perfect and is simple

Regards,

Gabriel

Gerard,
I created this formula for 3 years
Switch(Year([Start])=2005,DateDiff("ww",Dateserial(2005,1,1),[Start],2,2),Year([Start])=2006,DateDiff("ww",Dateserial(2006,1,1),[Start],2,2),Year([Start])=2007,DateDiff("ww",Dateserial(2007,1,1),[Start],2,2))
Yet I am having a problem of one week off in 2007...
Would you know what the problem is? I know I can probably force it ok adding
1 but would like to understand why

regards,

Gabriel

The formula could be that one, if your project is entirely scheduled on
2006:
DateDiff("ww";Dateserial(2006;1;1);[Start];2;2)
If the plan spans over several years, you'll have to improve the formula...

Gérard Ducouret

What I am actually looking for is a new column (number/date/text/etc) in the
table view that shows start in week number (without changing the standard
date format of the actual start column). I thought I could add a column,
could customize fields and enter a formula (that will take [start] as
argument) for this. Any comments on somebody that has done this?


:

Hello Garce,
As far as I know, MS Project complies with the ISO Standard for the weeks
numbering.
To display weeks numbers :
Format / Timescale /
Choose a level, Units : Week, Label : 1,2 ...52

Hope this helps,

Gérard Ducouret

"garce" <[email protected]> a écrit dans le message de
Anyone would have a formula to display week number. I am interested in the
ISO week number as described in Standard 8601
Under the ISO standard, a week always begins on a Monday, and ends on a
Sunday. The first week of a year is that week which contains the first
Thursday of the year, or, equivalently, contains Jan-4.