Forum Discussion

Underbudget007's avatar
Underbudget007
Copper Contributor
Dec 16, 2023

How can I add "working days" next to calendar days column in MS project?

Hi,

How can I add "working days" next to calendar days column in MS project?

  • Underbudget007

    By default the Duration field is in working days so I don't understand what you mean by "calendar days column". There is no "calendar days" field displayed as a column in Project.

     

    If you want the Duration field to be in calendar days, enter the value as "Xed", which means, "X" elapsed (calendar) days.

     

    If you want to have two fields shown as columns next to each other in the view, one the default Duration and the other a custom Duration field (e.g. Duration1), you can use the following construct:

    John

     

    John

  • John-project's avatar
    John-project
    Silver Contributor

    Underbudget007

    By default the Duration field is in working days so I don't understand what you mean by "calendar days column". There is no "calendar days" field displayed as a column in Project.

     

    If you want the Duration field to be in calendar days, enter the value as "Xed", which means, "X" elapsed (calendar) days.

     

    If you want to have two fields shown as columns next to each other in the view, one the default Duration and the other a custom Duration field (e.g. Duration1), you can use the following construct:

    John

     

    John

    • Underbudget007's avatar
      Underbudget007
      Copper Contributor
      Thank you, John! This is exactly what I was looking for to track calendar days. Some activities are measured by calendar days, and I am not sure why MS Project doesn't have this column as a standard option. I will use the formula you gave me for now. I appreciate your time and efforts in taking the time to respond to me. This is very helpful.
      • John-project's avatar
        John-project
        Silver Contributor
        Underbudget007,
        You're welcome and thanks for the feedback.

        As I noted, for those activities that you want in calendar days, enter the Duration as elapsed days. In those cases you might also want to create a custom 7 workday calendar and set it as the calendar to use via the Task Calendar field.

        John

Resources