5 Replies Latest reply: Jul 7, 2011 9:03 AM by Stefan Wühl RSS

    Counting valid / invalid contracts, based on dates

    Henco van Ee

      Hi all,


      I have a question about counting valid contracts and invalid contracts.

      A contract can start every half month, so I would like to count the number of valid / invalid contracts on every day / week / month.

      I read something about the interval function, but I am not sure on how to this. Could anyone of you please help me with this?


      Attached you find an example of my data.


      Kind regards,