Calculating % complete based on dates

I have a spreadsheet that has start and end times for certain events. I also have a column (column G) that is supposed to calculate the planned % complete based upon todays date. this column isn't working correctly.  Row 6 end date has not occurred so column G should not be showing 100% complete.

Also, in Column H I am trying to show Actual % complete with a bar showing a graphic representation of the Actual % complete.  this isn't working correctly either.

Any Help would be appreciated
TESTING-MILESTONE-FORMATS.xlsx
clarewcAsked:
Who is Participating?
 
Ganesh GuruduSenior ConsultantCommented:
you are referring wrong column
You should use below formula. Check and confirm.

=IF(TODAY()>=E6,100%,MAX((TODAY()-D6)/MAX(E6-D6,1),0))

also attached updated Excel
TESTING-MILESTONE-FORMATS.xlsx
0
 
clarewcAuthor Commented:
That seems to work great, Thanks

Any Idea how to deal with the Actual % Complete column?
0
 
clarewcAuthor Commented:
Thanks for the help, I am thinkin gI need to use conditional formatting for the actual % Complete
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.