4 Replies Latest reply: Jan 21, 2010 5:56 AM by Julien Bruchon RSS

    Date calculation with both fixed and unfixed end date

      Hi all,

       

      I have a customer file with a field "date of subscription" and a field "date of unsubscription". Both customers (still active and unsubcripted) are included in the file. For 'still active' customers, there is just "-" as data in "date of unsubscription".

      I'd like to count the number of days customers get a subscription. I have thus two problems :

      • write the good formula to calculate between 2 dates
      • evaluate each day who are the still active customers and recalculate the datas for them.

       

      I'd be glad if someone could help me. This is not very easy for a beginner coming from Excel,

      Thanks

       

      Julien