Forum Discussion

hall3cj's avatar
hall3cj
Copper Contributor
Aug 29, 2022

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 this is what I have but it's not returning what I expected. I would have expected 5 business days but I'm getting back 6. Here are the values for each cell. D3495 = 8/22/2022 (when I started the task), I3495 = blank.

 

=IF(ISBLANK(I3495), NETWORKDAYS(D3495,TODAY()), I3495-D3495)

excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 29, 2022

    hall3cj 

    You don't use NETWORKDAYS in the value-if-false part. Do this instead:

     

    =NETWORKDAYS(D3495,IF(I3495="",TODAY(),I3495))

    • hall3cj's avatar
      hall3cj
      Copper Contributor
      Aug 29, 2022
      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.

Resources