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))
Thanks for cleaning that up for me. Looking back part of my problem was counting the day I start working on it. Which I can just subtract 1 if I don't want to count it.