jonybandana
New Member
- Joined
- Dec 16, 2022
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hello! I am trying to build a celendar using [Year-week number] as a numbering scale to try to build a Gantt diagram. My idea is to have something like this:
My idea is to basically have the numbering end on 2352 (Since there are only 52 weeks in the year) and then start on 2401, so that I can then make the Gantt chart based on that info using conditional formatting.
Can I do this somehow?
Thank you!
Project | Act1 | Act1 duration | Act2 |
test project 1 | 2351 | 10 | 2361 |
test project 2 | 2348 | 10 | 2358 |
My idea is to basically have the numbering end on 2352 (Since there are only 52 weeks in the year) and then start on 2401, so that I can then make the Gantt chart based on that info using conditional formatting.
Can I do this somehow?
Thank you!