Forum Discussion
Having 2 agenda's in one project?
Hello,
I made a project planning with Microsoft project.
However im trying to get colums with days.
One is working days (this is default i believe) and the other one should be calendar-days.
This means that if a task takes from 01-01-2019 to 06-01-2019 one colum should state its 4 (working)days and the other should state its 6 (calendar) days.
How do i get this to work?
the example is in the appendix.
Thanks in advance for spending time to help me :)
- Ade_Budiman_LimBrass Contributor
Steinrusman Perhaps you could try out with using formula Finish Date - Start Date ? While the working days should be there by using Duration?
- Behzad78Copper Contributor
Pretty much as Ade_Budiman_Lim referred, more detail as below:
1- Right Click => Insert Column
Steinrusman wrote:Hello,
I made a project planning with Microsoft project.
However im trying to get colums with days.
One is working days (this is default i believe) and the other one should be calendar-days.
This means that if a task takes from 01-01-2019 to 06-01-2019 one colum should state its 4 (working)days and the other should state its 6 (calendar) days.
How do i get this to work?
the example is in the appendix.
Thanks in advance for spending time to help me :)
2- Select Number1 (or Any Number column from 1 to 20)
3- Right Click on the column => Select "Custom Fields"
4- Select Formula radio bottom
5- Select Formula to open "Formula for "Number1"
6- Put the formula => int([Finish]-[Start])
PS: You need to use "integer" because date are formatted as dd/mm/yyyy HH:MM am/pm but you probably don't need the decimal in your report
7-Ok
Result: You will get the difference between "Finish" date and "Start" date Not considering non-working days.
For considering non-working days, simply using "Duration" column and proper calendar.
Hope it helps!
- tweetiepie1983Brass Contributor