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