topic Excluding weekends from one date minus another.. in QlikView https://community.qlik.com/t5/QlikView/Excluding-weekends-from-one-date-minus-another/m-p/143825#M22942 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>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..</P><P></P><P>Thanks in advance,</P><P>Matt</P></BODY></HTML> Mon, 11 May 2009 21:04:16 GMT 2009-05-11T21:04:16Z Excluding weekends from one date minus another.. https://community.qlik.com/t5/QlikView/Excluding-weekends-from-one-date-minus-another/m-p/143825#M22942 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>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..</P><P></P><P>Thanks in advance,</P><P>Matt</P></BODY></HTML> Mon, 11 May 2009 21:04:16 GMT https://community.qlik.com/t5/QlikView/Excluding-weekends-from-one-date-minus-another/m-p/143825#M22942 2009-05-11T21:04:16Z Excluding weekends from one date minus another.. https://community.qlik.com/t5/QlikView/Excluding-weekends-from-one-date-minus-another/m-p/143826#M22943 <HTML><HEAD></HEAD><BODY><P>Yep. From the help file:</P><P>"networkdays ( start:date, end_date {, holiday} )</P><P>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.</P><P>Examples:</P><P>networkdays ('2007-02-19', '2007-03-01') returns 9</P><P>networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8"</P></BODY></HTML> Tue, 12 May 2009 00:43:13 GMT https://community.qlik.com/t5/QlikView/Excluding-weekends-from-one-date-minus-another/m-p/143826#M22943 johnw 2009-05-12T00:43:13Z