
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
look in Help for networkdays

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check this may be


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks all for that, i will check as advised
