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