5 Replies Latest reply on Apr 26, 2016 12:12 AM by Sumit Singla

# Hi, how can i calculate useful days?  Excluding weekends and holidays.

I need to know the difference between two dates, excluding weekends and holidays

• ###### 1. Re: Hi, how can i calculate useful days?  Excluding weekends and holidays.

Hi Danilo,

What is it you are trying to do and does Dan Huff's piece on Networkdays The power of NETWORKDAYS with Tableau help?

Steve

1 of 1 people found this helpful
• ###### 2. Re: Hi, how can i calculate useful days?  Excluding weekends and holidays.

Hi Danilo!

One option might be to use the solution outlined in the following Knowledge Base article:

Calculating the Number of Business Days | Tableau Software

Hopefully those steps help in creating your analysis

Thanks!

• ###### 3. Re: Hi, how can i calculate useful days?  Excluding weekends and holidays.

Exactly that, thanks!

• ###### 4. Re: Hi, how can i calculate useful days?  Excluding weekends and holidays.

Perfect! tks

• ###### 5. Re: Hi, how can i calculate useful days?  Excluding weekends and holidays.

Hi Danilo,

Below formula may help to find the number of days between 2 different dates excluding weekends.

DATEDIFF('day',[Order Date],[Shipment Date])+1 -datediff('week',[Order Date],[Shipment Date],'monday')*2