https://community.qlik.com/t5/App-Development/Networkdays-Question/m-p/1928051#M76428 <P>You should try something like</P> <P>Networkdays(<STRONG>Date#(abcddate,'YYYYMMDD'),today(1)</STRONG>) as NumberofNetworkDays</P> <P><A href="https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunctions/networkdays.htm#:~:text=The%20networkdays%20function%20returns%20the,account%20any%20optionally%20listed%20holiday.&amp;text=The%20start%20date%20to%20evaluate.&amp;text=The%20end%20date%20to%20evaluate.&amp;text=Holiday%20periods%20to%20exclude%20from%20working%20days." target="_self">Qlik Sense NetworkDays</A>&nbsp;&nbsp;</P> Mon, 09 May 2022 14:23:56 GMT danielrozental 2022-05-09T14:23:56Z https://community.qlik.com/t5/App-Development/Networkdays-Question/m-p/1926957#M76333 <P>Hi - I have a question about the Networkdays function.</P> <P>I presently have the following in my dataload:</P> <P>&nbsp;</P> <P><STRONG>Today(1) - Date(Date#(abcddate,'YYYYMMDD'),'MMDDYYYY') as NumberofDays</STRONG></P> <P>&nbsp;</P> <P>Works perfectly BUT I want to remove Saturday/Sunday from the calculation.</P> <P>Give the current format above of the date fields, what is the best way to approach this with the Networkdays function?</P> <P>&nbsp;</P> <P>Thanks - Jerry</P> Thu, 05 May 2022 15:03:25 GMT https://community.qlik.com/t5/App-Development/Networkdays-Question/m-p/1926957#M76333 jerryr125 2022-05-05T15:03:25Z https://community.qlik.com/t5/App-Development/Networkdays-Question/m-p/1928051#M76428 <P>You should try something like</P> <P>Networkdays(<STRONG>Date#(abcddate,'YYYYMMDD'),today(1)</STRONG>) as NumberofNetworkDays</P> <P><A href="https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunctions/networkdays.htm#:~:text=The%20networkdays%20function%20returns%20the,account%20any%20optionally%20listed%20holiday.&amp;text=The%20start%20date%20to%20evaluate.&amp;text=The%20end%20date%20to%20evaluate.&amp;text=Holiday%20periods%20to%20exclude%20from%20working%20days." target="_self">Qlik Sense NetworkDays</A>&nbsp;&nbsp;</P> Mon, 09 May 2022 14:23:56 GMT https://community.qlik.com/t5/App-Development/Networkdays-Question/m-p/1928051#M76428 danielrozental 2022-05-09T14:23:56Z