Hi- I'm fairly new to excel and this question will probably seem daft but I need to have a formula to determine the percent of tasks completed daily.
For example at the start of the week there are 100 tasks. On Tuesday, there are 75. Each day the number remaining is manually entered( there is not a report that can pull this) into the correct day field (Tuesday through close of business Friday-Friday morning being a separate number/cell) how do I get a rolling percentage completed so it updates every time a new number is entered in the weekday cells?
Thank you and I'm sorry if this makes no sense
Bookmarks