Ned to Create a new Calclulated Column

[weaselmcguff]

Have a table with a field called "Arrived Date" it will have a date value similar to December 1, 201

I am trying to create a calculated column that automatically tells me what week this is from.

How do I create a calculated column that provides this.

Thanks

 

[peter789]

=WEEKNUM([Arrived Date],x)
x depends on which of the many week number conventions you are using. I think ISO is 21 but it's a while since I last used it.

Peter

 

[weaselmcguff]

Thanks I used 1 for week begins on Sunday.

My original mistake was forgetting the ,x part

Appreciate the assistance.

 

[peter789]

No problem,
Just don't forget that the start of the year is also important. It creates a problem for global companies like the one I work for where US (Microsoft default) week numbers are different from the rest of the world.