https://community.qlik.com/t5/QlikView/Similar-script-function-to-lastworkdate/m-p/1569192#M441972 <P>I'm using&nbsp;<EM>lastworkdate</EM> in my script to work out X working days before my start date. However I've been told for some countries in my data the working week is Mon-Sat (not Mon-Fri). How can I do this? I've got a calendar and can easily get a list of all Sundays and Holidays to put in a variable take away from my start date, if only there's some way to take X days from my start excluding the dates in the list.&nbsp;</P> Sat, 16 Nov 2024 21:03:09 GMT shane_spencer 2024-11-16T21:03:09Z https://community.qlik.com/t5/QlikView/Similar-script-function-to-lastworkdate/m-p/1569192#M441972 <P>I'm using&nbsp;<EM>lastworkdate</EM> in my script to work out X working days before my start date. However I've been told for some countries in my data the working week is Mon-Sat (not Mon-Fri). How can I do this? I've got a calendar and can easily get a list of all Sundays and Holidays to put in a variable take away from my start date, if only there's some way to take X days from my start excluding the dates in the list.&nbsp;</P> Sat, 16 Nov 2024 21:03:09 GMT https://community.qlik.com/t5/QlikView/Similar-script-function-to-lastworkdate/m-p/1569192#M441972 shane_spencer 2024-11-16T21:03:09Z