My brain is fried - calculating total working days and keeping a running count

[ExcellinglyStupid]

Hello, hoping someone can help my immensely dense brain. The end goal here is that I want the value (amount of days) in a cell to change, depending on whether another cell has a date in it or not. Make sense? Hopefully it will…

I'm working with dates and business days; so I have a column for date when something was received (D2), and in another cell J2 I'm keeping track of the amount of working days since D2 date. I figured this formula out, but here's the tricky bit. I want that number to stop counting when a date is entered into ANOTHER cell, at I2. So I want the value cell (J2) to show amount of working days between the dates in D2 and I2, but I also want the days to keep on tracking if there is no date in I2.

In the screenshot below you can see the columns I'm referring to, and the existing formula there in J2 calculating working days so far. If any more resource is required, please explain in layman's terms and I'll do my best, any help would be greatly appreciated.

Thanks

 

[vmjan02]

Try this

=if(i2="",networkdays(d2,today(),i2-d2)

 

[ExcellinglyStupid]

Try this

=if(i2="",networkdays(d2,today(),i2-d2)

Hi, thanks for responding! I've tried that and it's suggesting there's a typo, when I approve Excel to amend the typo it changes the cell to #NUM! , if I don't accept the correction then it says that the formula is missing an opening or closing parenthesis...

 

[vmjan02]

ok, excel should have done it by itself

now try.

=IF(I2="",NETWORKDAYS(D2,TODAY()),I2-D2)

 

[ExcellinglyStupid]

ok, excel should have done it by itself

now try.

=IF(I2="",NETWORKDAYS(D2,TODAY()),I2-D2)

Hi vmjam, thanks for getting back to me I really appreciate it. I've tried the new formula, it seems to calculate working days right when I2 is blank, but when I input a date into I2, it's changed the value cell to calculate the amount of days including weekends. I'd like it to still show the amount of working days, if at all possible.