Forum Discussion

Steinrusman's avatar
Steinrusman
Copper Contributor
Jun 07, 2019

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

 

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

  • Behzad78's avatar
    Behzad78
    Copper Contributor

    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!

Resources