4 Replies Latest reply on Apr 18, 2016 6:20 AM by Łukasz Majewski

# FAQ:  Holidays & Workdays

Recommended

The power of NETWORKDAYS with Tableau

Resources

Meaning of Formatting

2014-05-22  Ignored

Questions

2015-12-21    Calculating Prior Business Day

2015-10-13    Help with calculating # of business days

2015-06-16    Work Days

2015-06-08    Weekend Exclude

2015-04-18    Business Dates calcuation

2015-02-23    Custom months comparison

2015-01-06    How to caliculate public holidays ?

2015-01-01    How to join two tables in custom Sql?

2014-12-31    Employee Utilization Report

2014-12-23    Exclude holidays which falls on weekends

2014-12-01    Blending start, end and in-between dates

2014-11-24    How to determine the last work day?

2014-10-28    Exclude weekends and holidays

2014-08-18    How to create a date field with numbers

2014-07-24    Dynamic input values for Parameter

2014-07-01    Net Working Day Calculation?

2014-06-20    datedif business days?

2014-06-16    Filtering out an Autoupdate Date

2014-06-09    Net Working Day Calculation

2014-05-30    Creating an event calendar

2014-04-29    Date difference using business days

2014-04-15    Calculating Networkdays with Tableau

2014-03-17    Loop for Date Increment

2014-01-17    Sum of Business Hours/Minutes?

2013-07-12    Business days difference between dates

2013-05-13    The power of NETWORKDAYS with Tableau

2013-05-09    Calculating Working Days between events

2013-04-04    TY vs. LY Weekly Comparison

2013-04-03    How to count days of week in tableau?

2012-12-17    Holidays

2012-11-05    Back to filtering Holidays

2012-09-04    working with the concept of working days

2012-06-27    Computing work days between 2 days

2012-06-19    # of Working weekdays in a month?

2012-05-15    DateDiff for Working days only

2012-04-30    Average Number of Workdays

2012-04-23    Calculating a pace??

2012-04-20    Setting Business hours?

2011-02-16    calculate total sales base on work days

2008-10-09    The specified item was not found.

Ideas

2015-03-18    Add Days of Week to Datediff Function

2015-01-18    Custom Calendar Tables

2015-01-12    EASTERSUNDAY(year)

2013-04-14    New Calculation Function - prevworkday

2013-04-14    New Calculation Function - ddiffbus

2012-08-30    Date Functions

2012-02-23    User Defined Functions

Other FAQ collections:   FAQ Hub

• ###### 1. Re: FAQ:  Holidays & Workdays

WOW!

Many thanks Johan, excellent collation of useful topics/ conversations!!

Do you have different versions of the above covering other areas?

Mark

• ###### 2. Re: FAQ:  Holidays & Workdays

Great collection, Johan. The links on Date/Time are quite significant and pretty exhaustive.

• ###### 3. Re: FAQ:  Holidays & Workdays

Hi Kettan,

Just came across a thread where your links were referenced and was curious to verify a very simple looking method of "Calculate the Number of Business Days Between Two Dates" from the Knowledge Base Calculating the Number of Business Days | Tableau Software

Here is what it says now:

Well it seems wrong. I attached a 9.2 workbook which show a sample of dates and this calculation made in 3 ways:

• in Excel - using - NETWORKDAYS.INTL function - as NETWORKDAYS_1 field (blue)
• the calculation from the above KB named [Calc from Tableau] (red)
• my method - much more complicated though - named [BusinessDays (row level)] (green)

(I presume Saturday & Sunday are weekend days)

While my calculation agrees with excel the KB one yields:

-5 for dates: 2016-04-02 & 2016-04-03

12 for 2016-04-10 & 2016-04-19

which is obviously wrong ...unless I am missing something

• ###### 4. Re: FAQ:  Holidays & Workdays

Right, I did miss one thing: the KB solution requires this setting (Sunday as Week Start):

But still it yields strange results:

Fri-Sun        =      0

Sun-Mon      =      1

Mon-Tue      =      1

does not seem right to me...