Kč - Kč ( ) - £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ Kč - Kč Kč - Kč Kč - Kč Kč - Kč $ - $ € - € - € / / / / € - € Kč - Kč Kč - Kč Kč - Kč Kč - Kč - - - - - - Kč - Kč - Kč - - Kč - Kč - Kč : : : : Yes Yes No True True False On On Off ¥€ ( € ) . . ??? Page 1 ??? (???) 00.00.0000, 00:00:00 Page 1 / 99 COUPDAYS Function Result PRAVDA Sheet Result Description 1 PRAVDA Simple COUPDAYS formulas with local references and values Function Expected Correct FunctionString Comment Data Description 182,5 182,5 PRAVDA =COUPDAYS("2001-01-25"; "2001-11-15"; 2; 3) 25.01.2011 Settlement date 181 181 PRAVDA =COUPDAYS(I2;I3;I4;I5) 15.11.2011 Maturity date 180 180 PRAVDA =COUPDAYS("2001-01-25"; "2001-11-15"; 2; 0) 2 Semiannual coupon (see above) 181 181 PRAVDA =COUPDAYS("2001-01-25"; "2001-11-15"; 2; 1) 1 Actual/actual basis (see above) 180 180 PRAVDA =COUPDAYS("2001-01-25"; "2001-11-15"; 2; 2) 180 180 PRAVDA =COUPDAYS("2001-01-25"; "2001-11-15"; 2; 4) 360 360 PRAVDA =COUPDAYS("2001-01-25"; "2001-11-15"; 1; 4) 90 90 PRAVDA =COUPDAYS("2001-01-25"; "2001-11-15"; 4; 4) Err:502 error PRAVDA =COUPDAYS("2001-01-25"; "2001-11-15"; -4; 4) basis 0 90 90 PRAVDA =COUPDAYS("2001-01-25"; "2001-11-15"; 4; ) 1 Err:502 error PRAVDA =COUPDAYS("2001-11-15";"2001-01-25"; 4; 1) 2 90 90 PRAVDA =COUPDAYS("2001-01-25"; "2001-11-15"; 4 ) 3 Err:502 error PRAVDA =COUPDAYS("2001-01-25"; "2001-11-15"; ) 4 4