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 ?
Member for
21 years 8 months
Member for21 years8 months
Submitted by Rafael Davila on Tue, 2023-08-22 13:14
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)
Member for
14 years 7 monthsThanks Rodel, Rafael, I am
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 ?
Member for
21 years 8 monthsAny such formula that misses
Any such formula that misses to consider CPM calendars (work hours, iregular work days and resource availability ...) will be wrong and misleading.
Member for
19 yearsHi Jithin,the simple formula
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)