Networkdays with saturday

[Anonymous]

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.

[acorral312]

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

[ashishpalkar]

Hi There

How can we get Networkdays without Saturday or Sunday?

Thanks in advance,

[rbecher]

networkdays - script and chart function ‒ QlikView

[suhaskharat]

how can we do to exclude 2nd and 4th Saturday and all Sundays of all months from date range

[EQ]

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

[smgt90]

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.