net work days

[Anonymous]

Hello again,

I want to calculate the number of working days between two dates excluding Saturday only.

the function networkingdays excludes Saturday and Sunday also.

how can i do it without having a tables with records for everyday in the period. (using Join) .

Thanks,

Naor

[Gysbert_Wassenaar]

Try this one:

Interval(

     rangesum(

          Date2-Date1,

          -If(Weekday(Date1)=5,1),

          -Div(Date2-Date1,7), -If(WeekDay(Date2)<Weekday(Date1),1),  if(WeekDay(Date1)=5,1)

     )

)

[sunny_talwar]

Not the best of ways, but seems to work

Expression:

((Floor(WeekStart(End)) - Floor(WeekEnd(Start)) - 1) *(6/7)) + (Floor(WeekEnd(Start)) - Start) + (End - Floor(WeekStart(End)) + 1)

[Anonymous]

Hi Gysbert ,

first of all - thank you! but unfortunately is doesn't work well - the answer between 4/1 and 1/1  shows 3 days but it should be only 1 working day (Friday).

[Anonymous]

Hi,

take a look at the answer of the expression you suggested - (TRY11)

i'm trying to use it in the script but unfortunately is doesn't work well.

any idea?

Thanks!!

[Anonymous]

did you check this?

NetWorkDays

[Anonymous]

Hi Balraj,

Yes i checked it but this is what i need - full working days (means that between 13/1 and 12/1 there are 0 working days) between the rows without Saturday.