Is it possible to hide dates in a project plan and display week 1, week 2, etc.?
I'm setting up a project where the start date is still to be determined.
I have been asked to provide a column that has the week a certain activity needs to occur in. For example, instead of kicking off the project on 25/09/2023 the Grid View of the project plan should have a column in it that shows the project kicking off in Week 1.
Later activities should show how many weeks it's been since the start date. For example, if it's a 15 week project, the go-live would be in week 15.
Is there a way to do this through formulas?
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!