Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
guillaume_gorli
Contributor

Bank holidays and week end

Hi All,

What would be the formula to get the difference between two date taking into account week end ?

For instance :

Date1 = Friday July the 21st

Date2 = Monday July the 24th

The difference between Date1 & Date2 should be 1

Last question, is there a way to take into account bank holidays as well ?

For instance July the 14th is bank holiday in France :

Date1 = Thursday July the 13th

Date2 = Monday July the 17th

The difference between Date1 & Date2 should be 1


Thanks in advance


Guillaume

1 Solution

Accepted Solutions

Re: Bank holidays and week end

4 Replies
mwoolf
Honored Contributor II

Re: Bank holidays and week end

look in Help for networkdays

Re: Bank holidays and week end

zhadrakas
Valued Contributor

Re: Bank holidays and week end

Usually you are using the networkdays function for that case.

That calculates the Difference between StartDate and EndDate excluding specific Holidays.

NetWorkDays(vStartDate ,vEndDate, '$(vListOfHolidays)')

For More Information about that see this threads:

Exclude holidays using Networkdays() in script

Network days less Public Holidays | Qlik Community

guillaume_gorli
Contributor

Re: Bank holidays and week end

Thanks all for that, i will check as advised