I am trying to create a simple Gantt chart that shows project milestones and durations.
Using NETWORKDAYS does not compute the correct time for duration, since it skips some calendar days.
However, if I simply subtract Start Date From End Date, I get 0 for tasks that only take one day (they begin and end on the same day). That method works correctly for all other days.
Is there a way to simply count the correct number of calendar days (so that the gantt chart shows dates correctly), but still shows one-day tasks as one full day?
Thanks.
Bookmarks