Quote:
Originally Posted by 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
|
Claus,
I am forever grateful - thank you so much!
noia