Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Could somebody tell me which expression I have to use te make the difference between 2
dates in workdays ?
Thanks in advance.
Marc
Use the networkdays function
networkdays (start:date, end_date {, holiday})
Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.
Examples:
networkdays ('2007-02-19', '2007-03-01') returns 9
networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8
firstworkdate(end_date, no_of_workdays {, holiday} )
Hi
Thank you for the information.
Marc