Having 2 agenda's in one project?

Copper Contributor

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 :)

 

3 Replies

@Steinrusman Perhaps you could try out with using formula Finish Date - Start Date ? While the working days should be there by using Duration?

@Steinrusman 

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!

@Behzad78 

 

Agree, this solution should work.