Project Sheet with Gantt Chart - End Date issue

Question

Hello,

I am putting together a sheet that will track construction projects. The sheet includes a Gantt Chart (Sort of).

I hope I can explain this correctly.

The sheet has the following columns:  Project, Days Duration, Start Date, End Date.  The time between the Start and End dates are reflected in the Gantt chart to the right of the sheet where each box corresponding to a specific day between the dates is colored.

What I would like to do is add a column "Days Remaining" that will indicate the number of days remaining to complete the project based on the Start and End dates.  The start dates for project (one per row) are different for each, so the Gantt chart shows they start in different dates. The column Remaining Days would have to do a count down once today's date reaches the Start Date and each day that passes.  

I watched many videos, but I did not find one that does this type count down once a date is reached.

Thank you in advance for any assistance.

Answer 1

Excel 2016 Pro Plus with PowerPivot, VBA and Defined Names.

With real Gantt chart.

With one minute resolution, over several days.

Accounts for working hours, lunch breaks, weekends and holidays.

Calculates working hours to go on unfinished projects.

Calculates completion date and time.

http://www.mediafire.com/file/pbwrda9020z5vo2/12_16_15a.xlsm