Hello All
Need your support in excel.
Need to calculate % complete based on duration consumed from dates with an IFS formula
The table
Start
Finish
1-Jul-23
12-Jul-23
15-Aug-23
30-Aug-23
15-Sep-23
10-Jul-23
24-Aug-23
0%
7%
80%
100%
100%
46
Duration Complete
3
37
46
46
Thanks
Jithin
Thanks Rodel, Rafael,
I am looking for a formula to populate the below table ie when I pull the fosrula from D3 to H3 it automatially gives the % complete based on the dates in D2 to H2.
So the Duration based progress % (C3-B3+1) and the % changes based on D2 to H2.
[[wysiwyg_imageupload:8470:]]
Any thing on that ?
Any such formula that misses to consider CPM calendars (work hours, iregular work days and resource availability ...) will be wrong and misleading.
Hi Jithin,
the simple formula is = (Date - Start + 1) / (Finish - Start + 1)
Say Column A= Start, Column B = Finish, Column C = Date ... and so on, then Row 1 & Row 2
=(C$1-$A$2+1)/($B$2-$A$2+1)
Note: Assumption - date does not have time entry that is why it needs +1. If time is included on the entry (ex: 8:00 AM to 5:00 PM) therefore + 1 is not required)