8 Replies Latest reply: Jan 15, 2015 9:43 PM by guan tujiang RSS

    the count if did not work ?

    guan tujiang

      I would like to have a count of working day base the loaded list, so I try in the count if command,

      it work if it write down the date with string,just as

       

      =Count(if(CALENDERDATE < '15.01.2015', ISOFFICEHOLIDAY))

       

      even work with

       

      =Count(if(CALENDERDATE < today(), ISOFFICEHOLIDAY))

       

      the result should be 104 ( working day)

       

      but it will fail if I try as below

       

      =Count(if(CALENDERDATE < DATADATE, ISOFFICEHOLIDAY))

       

      the result show 402 or some other more.

       

      the DATADATE was flited out by selected list in dataday & datamonth & datayear, if I try the formula in a text object

       

      =DATADATE

       

      it show with the right result just as : 05.10.2015

       

       

       

      what happened??

       

       

      =====================

      list as below:

      CALENDERDATE ISOFFICEHOLIDAY
      30.09.20140
      01.10.20141
      02.10.20141
      03.10.20141
      04.10.20141
      05.10.20141