Hello,
I have a worksheet that contains a start and end date of tasks, I would like to know why the percentage says 100% when the date of completion has two days to complete.
In column C: I have the start date
In column D: I have the end date
In column E: the number of days to complete the task, excluding weekends and stat holidays
In column F: the % completed
The first task's start date was September 15, 2016 and the end date is October 28, 2016, the current formula I have is the following:
=IF(TODAY()<C4,"",MIN(1,(TODAY()-C4)/E4))
Why is the percentage complete says 100% when there are 2 days left to complete?
Thanks
Bookmarks