Excluding weekends from one date minus another..

[#1]

HI,

as the subject suggests, i'm wondering if QlikView is able to subtract one date from another and return a umber of days which does not include weekends..

Thanks in advance,

Matt

[johnw · Accepted solution]

Yep. From the help file:

"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"