Bank holidays and week end

[guillaume_gorli]

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

[m_woolf]

look in Help for networkdays

[sunny_talwar · Accepted solution]

Check this may be

networkdays - script and chart function ‒ Qlik Sense

[zhadrakas]

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]

Thanks all for that, i will check as advised