| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Completion Percentage of a date range
I have started a task sheet in excel and i have a "task description" coloumn,
a "start date", "finish date", "number of days" and a "% complete" column. What i want to achieve is the user to enter the first task start date and the number of days it will take to complete. Then excel will work out the end date and the percent complete field relating to the current date. Is there a easy formula of working out the percentage? Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set a date range for conditional formatting in a macro? | Excel Worksheet Functions | |||
| SUMPRODUCT with date range question | Excel Discussion (Misc queries) | |||
| Estimated date of completion | Excel Worksheet Functions | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
| How can I sum information in a list with a date range? | Excel Worksheet Functions | |||
Threaded Mode
