Calculating Networkdays, but when blank cell use todays date

[marsanabanana]

I am trying to calculate the networkdays that documents are open. I have three columns "Date Opened" "Date Closed" and "Days Open" sometimes the date closed is blank so days open returns blank using: =IF(I40<>"",NETWORKDAYS(H40,I40),"")

BUT I'm trying to chance it to if its blank it will just use today's date to calculate the number of days open but not put anything in the date closed column. I'm not sure if this is even possible, but it seems like it would be able to be done.

If (date closed is blank, networkdays (Date opened, todays date), networkdays (date opened, date closed)

=IF(ISBLANK(C276),NETWORKDAYS(B276,Today)-1,NETWORKDAYS(B276, C276)-1)) <-----something along these lines but one that actually works

Help is greatly appreciated thank you!!

 

[barry houdini]

Try this version

=NETWORKDAYS(B276,IF(C276="",TODAY(),C276))-1