Using Networkdays function with named cell ranges

[stubrave]

Hi all,

I have designed quite a complicated nested if statement that carries out different calculations depending on whether certain fields are blank or not. I have 30 columns and I have renamed each with reference to the time point I am referring to (e.g. feas1 feas2 etc - (FEAS referring to 'Feasibility' in case you were wondering).

I would like to refer to the range name rather than the individual cell reference within the If statement, but when I do so I am met with a #VALUE error message.

My formula looks like this. It works when it's simply x-y, but not when the calculation is using networkdays for some reason. I can only get Networkdays to work when referencing individual cells (e.g. a1, b2) rather than range names (e.g. feas1, feas2).

The full if formula is as follows, in case this is useful:

=IF(AND(ISBLANK(feas1),ISBLANK(feas2))," ",IF(AND(NOT(ISBLANK(feas1)),NOT(ISBLANK(feas2))),feas2-feas1,IF(AND(ISBLANK(feas1),NOT(ISBLANK(feas2))),"Enter start point",IF(AND(NOT(ISBLANK(feas1)),ISBLANK(feas2)),TODAY()-feas1," "))))

Any advice would be appreciated.

Thank you.

Stuart