3 Replies Latest reply on Mar 29, 2018 9:38 AM by Paul Sutherland

    Calculate number of weekdays between two dates

    chandan mishra

      Hello

       

      I am trying to calculate two date difference:

       

      1) Number of Weekdays (exclude weekends) between today() and the beginning of the quarter. For example, if today is 29th March 2018 and beginning of quarter is 1/1/2018, I am using this calculation but it doesn't seem to work:

       

      DATEDIFF('weekday',DATETRUNC('quarter',TODAY()),TODAY())

       

      2) Number of Weekdays (exclude weekends) between the beginning of the quarter and end of a quarter: Not sure how to calculate the end of a quarter in tableau.

       

       

      Please help me out with this.

       

      Thanks

      Chandan Mishra