Excel formula help
Posted on 2014-11-19
Hello, I have an excel spreadsheet with a great deal of data. I'm looking for a few clean formulas to make the process better/work.
there overall report is about 8000 line items detailing task assignment. The current spreadsheet includes: Department, Task assignment date, task compeltion date. Please note the task is due 20 days after open.
So, What i need to pull is a report/sheet with the following columns of information:
-Number of Task by Department
-Number completed by due date
-Number still open (no completion date)
-Number NOT competed on time (includes those that were compelted after the 20day due date and those not completed at all(no completion date))
-Percentage of tasks completed late (includes not compelted)