5 Replies Latest reply: Apr 16, 2009 7:02 PM by Mark McCoid RSS

    can't get sumif formula to work correctly

    sunny

      Hi i have the expression below;

      Sum



      (IF(MOTRenewal=today()+14,1))

       



      This works however it doesn't do what i need it to. I want it to show all MOT's due from today up until 14 days going forward. The expression above however only shows whats due in 14 days, so for example it will only show the MOT's due on the 30th April as that is 14 days from today and nothing else, I need it to show everything else in between today and the 14 days. How can I get this to work please assist.

      Sunny