2 Replies Latest reply on Oct 19, 2016 12:53 PM by Abhinav Kumar

    Finding datediff while excluding weekends

    Abhinav Kumar

      Hi All,

       

      I am trying to write a calculated field where I have a column named LastUpdated. I am trying to find the rows whose difference between LastUpdated and Today's date is greater than 30 while excluding the weekends.

      For example: If LastUpdated was on Aug 1, 2016 then even after excluding weekends it will show in the row but same is not true for a row having LastUpdated from Sept 15 because the difference is less than 30.

       

      I am able to write the datediff function, but I don't know how to find the range from where I can exclude the weekends.

       

      My data source is excel and I am using Tableau 8.3

       

      Thanks in advance.