| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculating days spent to complete a task
Hi,
I am trying to calculate days spent to complete a task using three dates: 1 - Date task was logged 2 - Date of completion 3 - =TODAY() (and this is where I can't figure out the formula) IF there is no completion date entered, I would like it to calculate the days based on today's date It would be ideal if this could also exclude weekends, however, this is not vital. Your help is much appreciated!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating working hours to complete a task | Excel Worksheet Functions | |||
| Calculating hours per week spent by a resource | Excel Discussion (Misc queries) | |||
| formula to calculate amount of hours downtime spent in days | Excel Worksheet Functions | |||
| Calculating hours spent per team | Excel Discussion (Misc queries) | |||
| Not able to complete the task? | Excel Discussion (Misc queries) | |||
Threaded Mode
