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