Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have to count how many working days there are between two dates, but I have to consider that Saturday is ALWAYS a working day, so I cant's use the networkingdays() function, which excludes Saturday. At the same time, I can't use a calendar because I have to use the calculation for many occurrences in various years, so it should be too difficult for me to load a so long calendars.
Can anyone suggest an idea to me?
Thank you for interesting.
Hi Ralf,
I would like to use your solution to find the number of working days remaining in the month (Monday-Saturday). Is there a way to exclude a list of holidays?
AC
Hi There
How can we get Networkdays without Saturday or Sunday?
Thanks in advance,
networkdays - script and chart function ‒ QlikView
how can we do to exclude 2nd and 4th Saturday and all Sundays of all months from date range
Hi Ralf,
It is very useful but it seems not fully fit for my case.
Could you please provide how to calculate how many Saturdays or Sundays between two dates?
BR,
Eric
Can you help me with a similar formula that I could use as an alternative to the LastWorkDate formula? I need it to count Saturdays as working days.