I just figure out a easy calculation for net work days between two dates. ( assuming 5 working days a week)
Datediff('day',[First Date ],[Last Date])+1
Datediff('week',[First Date ],[Last Date])*2
-IF datename('weekday',[First Date])='Sunday' THEN 1 else 0 end
-IF datename('weekday',[Last Date])='Saturday' THEN 1 else 0 end
I am still woring on put any holidy in the formula. If you have any idea, you are wel come to imput.
If you have any question, please let me know
Hi there, this is really useful and seems to work great.
I'm new to Tableau and calculations, would it be possible for you to briefly explain the logic, how the calculation actually works?
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...