Hello,

I am new here! It seems like a useful place to come.

Ok so I have encountered a problem, I have created a table in excel and input data using the form button. I have a formula in one of my cells and is as follows:

=IF(ISBLANK(S2),"",IF(NETWORKDAYS.INTL(MAX(D2:F2),S2-1,1)<1,1,(NETWORKDAYS.INTL(MAX(D2:F2),S2-1,1))))

Now I have got the exact same formula in a separate sheet and it works fine, the 2 sheets are identical, in fact I just copied the first sheet. However when I enter a data into the second sheet excel does this:

=IF(ISBLANK(S2),"",IF(NETWORKDAYS.INTL(MAX(D3:F4),S2-1,1)<1,1,(NETWORKDAYS.INTL(MAX(D3:F4),S2-1,1))))

Where it should be MAX(D3:F3) in both instances. It also changes the original one to MAX(D2:F3) but it was fine before I entered more data in.

Is there something horrifically wrong with my formula? Why does it work on the original sheet?

Any help would be absolute fantastic. Btw I am running excel 2010.

Thanks