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!!!