Forum Discussion
Underbudget007
Dec 16, 2023Copper Contributor
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?
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-projectSilver Contributor
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
- Underbudget007Copper ContributorThank 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-projectSilver ContributorUnderbudget007,
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