Is there a way I can count all the tasks in a gantt chart that occur on any day in a project?

Johnboy

Hi all,

I have a project Gannt chart with several hundred tasks. I have a column that identifies which are actual tasks (not roll-up summary tasks). Is there a way I can count the number of tasks that fall on any particular day from the start to the end of the project, to build a 'number of tasks per day' histogram over the project's duration?

Thanks in advance for any guidance,

John

Paul Newcome

You would start with a separate sheet that has ever day listed down a date type column. Then you would use a COUNTIFS with cross sheet references to count how many rows in your project plan are marked as actual tasks, have a start date less than or equal to the date in the date column, and an end date greater than or equal to the date in the date column.

Paul Newcome

You would start with a separate sheet that has ever day listed down a date type column. Then you would use a COUNTIFS with cross sheet references to count how many rows in your project plan are marked as actual tasks, have a start date less than or equal to the date in the date column, and an end date greater than or equal to the date in the date column.

Johnboy

Thanks Paul, Much appreciated.

Great idea. I'll give it a try and come back if I make a mess of it.

Cheers,

John

Paul Newcome

Happy to help. 👍️