I'm trying to create a formula that will allow me to use the =NETWORKINGDAYS(start, end)-1 formula if a cell contains a data or the =TODAY()-cell if the cell is blank, but I can not figure it out. I'm trying the IF statement, but I know I've got errors. Here is what I've tried =IF(X2=" ",[NETWORKINGDAYS(N2,X2)-1],IF[X2=<>" ",[TODAY()-N2]).



Each formula works separately, but I can't figure out how to combine these to use the formula applicable to being either blank or not blank
.

Any advice, it's been quite a while since I've done something like this.
Thanks