Calendar Days

S

Shannon

Can someone tell me how I can have project show me the calendar days that a
project will last? I use the standard calendar as the calendar for my
project. What I need to see if a project start is July 1st and based on the
task durations and relationships the proejct is ending July 31st....I want to
show 31 days for the calendar days in a column...not just the working days.
 
J

John

Shannon said:
Can someone tell me how I can have project show me the calendar days that a
project will last? I use the standard calendar as the calendar for my
project. What I need to see if a project start is July 1st and based on the
task durations and relationships the proejct is ending July 31st....I want to
show 31 days for the calendar days in a column...not just the working days.

Shannon,
Unfortunately there is no option to directly show calendar days but you
can use a spare text field customized with a formula to show calendar
days. Use the following formula,
Text1=DateDiff("d",[Start],[Finish])+1 & " days"

You probably also want to use the formula for calculating task and group
summary rows.

Hope this helps.
John
Project MVP
 
S

Shannon

Thanks John...that worked perfectly!

John said:
Shannon said:
Can someone tell me how I can have project show me the calendar days that a
project will last? I use the standard calendar as the calendar for my
project. What I need to see if a project start is July 1st and based on the
task durations and relationships the proejct is ending July 31st....I want to
show 31 days for the calendar days in a column...not just the working days.

Shannon,
Unfortunately there is no option to directly show calendar days but you
can use a spare text field customized with a formula to show calendar
days. Use the following formula,
Text1=DateDiff("d",[Start],[Finish])+1 & " days"

You probably also want to use the formula for calculating task and group
summary rows.

Hope this helps.
John
Project MVP
 
J

John

Shannon said:
Thanks John...that worked perfectly!

Shannon,
You're welcome and thanks for the feedback.
John
John said:
Shannon said:
Can someone tell me how I can have project show me the calendar days that
a
project will last? I use the standard calendar as the calendar for my
project. What I need to see if a project start is July 1st and based on
the
task durations and relationships the proejct is ending July 31st....I
want to
show 31 days for the calendar days in a column...not just the working
days.

Shannon,
Unfortunately there is no option to directly show calendar days but you
can use a spare text field customized with a formula to show calendar
days. Use the following formula,
Text1=DateDiff("d",[Start],[Finish])+1 & " days"

You probably also want to use the formula for calculating task and group
summary rows.

Hope this helps.
John
Project MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top