Spreadsheet attached...
I'm trying to summarize project status data to calculate:
A) How many projects are there?
B) How many are completed?
C) How many of the projects were completed "on time"?
D) What projects are coming due, or overdue.
I started to create a summary, counting projects and "completed" based on whether or not there was a date (numerical value) in the cell...then calculated the percentage based on those two numbers - that was easy.
Now, I'm having trouble getting the next step - calculating how many of those projects already completed were "late" (completed past the due date), and how many projects are currently overdue.
After that, I wanted to format the entire rows (shaded Red - overdue, Orange - coming due within 15 days, and yellow - due within 30 days)...
Any help would be appreciated...thank you.
Bookmarks