#1
|
|||
|
|||
Display Activities by Day Number
Hello everyone,
Our executives have asked for a list of major project activities by day number. For example: If day 1 is January 15th (the start date of the project) and the next major activity is on January 20th, then that activity would fall on "Day 5". Is there anyway to automatically have the day number calculated and displayed in the Gant chart (or a report)? I've attached a manual example. See column "Day". I hope I've explained this clearly. Thank you. |
#2
|
|||
|
|||
Hello Susan,
have you checked if the thread below can help you? https://www.msofficeforums.com/project/19706-how-calculate-edays.html |
#3
|
|||
|
|||
Hi Susan,
The Gantt chart timescale can display the day numbers instead of the date. Right click on the Gantt chart timescale and choose "Timescale" from the shortcut menu. Select the Bottom tier and select the appropriate label from the list. You may also calculate the number of days from the Project Start to the start of any other task. Add a text field (for example Text1) to the table. Right click on the field header and choose "Custom Fields" from the shortcut menu. Select "Formula" button in the custom attributes section to open the formula dialog. Enter the following formula: "Day" & " " & DateDiff("d",[Project Start],[Start]) This will produce an entry "Day 0" for the first task where the start date equals the Project start date. If you want to start with "day 1" as the start date of the first task enter a slightly modified formula: "Day" & " " & DateDiff("d",[Project Start],[Start])+1 |
#4
|
|||
|
|||
Resolved and Thank You!
Thank you codeghi. I'm not sure if changing the calendar working days will impact my overall dates.
Julie, all your recommendations worked perfectly. Thank you so much for the valuable help. This forum ROCKS! Cheers Susan |
#5
|
|||
|
|||
Great. I'm glad my recommendations go you what you needed and thanks for the feedback.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Differentiate certain activities from hypotetical activities in gantt chart | Serena | Project | 1 | 02-24-2014 10:47 AM |
Using the sum function to display number as well as words in a single cell | officeboy09 | Excel | 8 | 10-30-2013 05:38 AM |
Display unique values and count the number of child items | vthomeschoolmom | Excel | 2 | 07-25-2013 06:17 AM |
a rental period in between two activities | ketanco | Project | 5 | 10-21-2012 06:28 AM |
display number of characters in a word section | shootingluc | Word | 3 | 03-29-2012 03:25 PM |