SOLVED

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

Copper Contributor

Hi,

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

3 Replies
best response confirmed by Dale Howard (MVP)
Solution

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

2023-12-17_09-51-09.png

John

 

John

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.
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
1 best response

Accepted Solutions
best response confirmed by Dale Howard (MVP)
Solution

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

2023-12-17_09-51-09.png

John

 

John

View solution in original post