Calculating days spent to complete a task

[Noia]

Hi,

I am trying to calculate days spent to complete a task using thre
dates:

1 - Date task was logged
2 - Date of completion
3 - =TODAY() (and this is where I can't figure out the formula) IF ther
is no completion date entered, I would like it to calculate the day
based on today's date

It would be ideal if this could also exclude weekends, however, this i
not vital.

Your help is much appreciated!!

 

[Claus Busch]

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

 

[Noia]

Hi Noia,

Am Wed, 26 Sep 2012 11:51:39 +0000 schrieb Noia:
-

A1 is Start
B1 is End
Then try:
=NETWORKDAYS(A1,MIN(B1,TODAY()))

Regards
Claus Busch

Claus,

I am forever grateful - thank you so much!

noi