Hello I try to make IF-statement that do this:

IF
GETWORKDAYS(Installningar!$A$2;(DATE(200&(LEFT(N2; 1));1;-5)+(MID(N2;2;2)*7)+RIGHT(N2;1))-1)="#VALUE!"
not a value
GETWORKDAYS(Inställningar!$A$2;(DATE(200&(LEFT(N2; 1));1;-5)+(MID(N2;2;2)*7)+RIGHT(N2;1))-1))
but it don't work.

Can anyone here see what is missing?

In the cell Installningar A2 it says : 2005-10-04

Please help

/Ander

--
a94andw
-----------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=47300