5 Replies Latest reply on Sep 26, 2013 12:40 AM by Prashant Sharma

    DATEADD only business days (i.e. Monday - Friday)

    Kenny Parekh

      Hello All,

       

      Issue: Want to report the expected date when a customer will finish the number of daily payment installments.

      Ex: Product funds on Sept 29, and there are 30 total daily installments. Since customers can only make payments on BUSINESS days, I the expected payment would be finished 30 business days from September 29th. (Monday - Friday) So the expected date would NOT be October 29th (which is what Tableau would give me), but rather November 14, or 15. (Something like that)

      What I need:

      A DATEADD formula that will add BUSINESS DAYS to a given date for a more accurate expected date of finished payments.


      If someone could help me out with this, this may save me.


      Thanks,

      Kenny