How to exclude weekend Sunday only to DATEDIFF in Tableau

Question

My current formula is : DATEDIFF('day', MIN([Date]),MAX([Date])).

How do I exclude sundays and holidays from this?

Answer 1

To exclude Sundays from the DATEDIFF calculation in Tableau, you can modify the formula by using the WEEKDAY function:

DATEDIFF('day', MIN([Date]), MAX([Date])) - SUM(INT(WEEKDAY([Date])) = 1)

This formula subtracts the count of Sundays (where the WEEKDAY function returns 1 for Sunday) from the total DATEDIFF result, effectively excluding Sundays from the calculation.

Elevate your data visualization skills with our Tableau Course and unleash the power of insightful analytics.