Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
look in Help for networkdays
Check this may be
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:
Thanks all for that, i will check as advised