To include Saturday count in Networkdays

gp_123 — Tue, 24 May 2022 12:14:00 GMT

Hello Everyone,
I am working on the one of the project. I am calculating Pending for Field and for that I write this Expression.
IF(Area='Capgemini', NetWorkDays(TsOpeningDate,Today(),$(vCampgemini))-1,
NetWorkDays(TsOpeningDate,Today(),$(vOtherHolidays))-1) as Pending_for

Now i want to add Sat count into the same logic as networkdays function automatically excludes Sat Sun.
To add sat Count I performed this logic - Div(WEEKDAY(Min(TsOpeningDate)-6,0)+1-Min(TsOpeningDate)+Max(TsOpeningDate),7) using this logic I am getting number of sat between two dates but I am not getting how to combine this with the above logic.

How I can achieve this? If anyone have any idea please let me know.

Regards,

Ganesh

topic To include Saturday count in Networkdays in App Development

To include Saturday count in Networkdays