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!!! |
Calculating days spent to complete a task
Hi Noia,
Am Wed, 26 Sep 2012 11:51:39 +0000 schrieb Noia: 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 A1 is Start B1 is End Then try: =NETWORKDAYS(A1,MIN(B1,TODAY())) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Quote:
I am forever grateful - thank you so much! noia |
All times are GMT +1. The time now is 12:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com