How to create MS Project Column to display week number


F

fran.tartaglione

I would like to know if there's a way to use an existing or create a new column in the Task Sheet view that will return a number reprsenting the week in which a task starts. For instance, I would like to be able to group on such a field in order to display all columns which start in week 1, week 2,week 3, etc., of a project.

I am able to use "group by" to see which tasks start in a particular week, but find myself using a text column to manually number the weeks. Surely there's a better way.

Thanks in advance
 
Ad

Advertisements

Joined
Nov 27, 2015
Messages
1
Reaction score
0
Hey, try this formula in new column (as Text): "ww" & Datepart("ww";[Start];2;2) & "/" & Format([Start];"YY")

Then is displayed 4.1.2016 as w01/16
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top