Forum Discussion

yaya7's avatar
yaya7
Copper Contributor
Aug 02, 2025

Help with Gantt Chart Day Calculation

Hi all,

I'm currently working on a Gantt chart to track how long each person will be in the store. However, I've noticed that the number of days isn't calculating correctly. I'm trying to capture the full duration for each person, but something seems to be off in the formula or setup.

Any suggestions on how to fix it?

 

2 Replies

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor

    It's difficult to recommend a solution without seeing the workbook and the conditional formatting rules. It looks like your workbook is based off one of the Gantt templates. If you're able to share an anonymized workbook or point us to the template it will help you get a quick solution (or two).

  • Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources