Forum Discussion
Calculate Business Days Open
I'm trying to track the turn times for a task I do. I need to be able to see how many days I've been working on the task without counting the weekends. I'm not worried about holidays. Currently ...
You don't use NETWORKDAYS in the value-if-false part. Do this instead:
=NETWORKDAYS(D3495,IF(I3495="",TODAY(),I3495))