Display Activities by Day Number

[SusanK]

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.

[codeghi]

Hello Susan,
have you checked if the thread below can help you?

https://www.msofficeforums.com/project/19706-how-calculate-edays.html

[JulieS]

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

[SusanK]

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

[JulieS]

Great. I'm glad my recommendations go you what you needed and thanks for the feedback.