Good day,
I am running through some issues and or some headaches.
My work is based on doing tasks between 2 dates. I have a start and end date and these tasks must be completed within these ranges of dates.
I am not too good with formulas. I am looking to fix the workbook I have uploaded.
I need to know, in between the start and end date, what would be the percentage of my completed tasks and one would be if I am Late or ahead of schedule.
I have kind of started my formula but it makes no sense.
Another thing would be to know how many tasks I need to do in between the start and end date.
Example If I have 10 tasks to complete in 20 days then I need to accomplish .5 per day but if I have not started anything and have 5 days remaining, then I would need to complete 2 tasks a day in order to meet my deadline date.
I got no clue how to accomplish this.
Any help would be appreciated.
Copy 001.xlsm
Bookmarks