Ciao





I would like to create a table for my Gantt, that displays the week number unit instead of the date.
My goal is to create a table that instead of showing the start and finish date for a task, displays the start week: i.e. Week 1, Week 2, ...ect. and the finish week.
I have found in Internet this answer:

create a customized text field with the formula "Week " & CStr(1+datediff("w";[Project Start];[Start]))
For the finish date, in another Text field, replace [Start] by [Finish]

I have two questions:

1. Instead of "Project Start", can I use a fix date like 01-01-2015?
2. If I have a task that starts in 2015 and finishes in 2016, the formula shows a week number more than 52: how can I modify the formula in such way that it will be showed a week number 1 at the beginning of the year instead of 53?

Regards