Saturday half work day

[MyJoy]

Hi Everyone,

I'm not familiar with networkdays formula, trying to calculate number of work days from Monday to Friday and Saturday is half workday.
I've created the formula but seem incorrect answer

=(NETWORKDAYS.INTL("5/5/2021","10/5/2021",1)+NETWORKDAYS.INTL("5/5/2021","10/5/2021",17)+1)*0.5

 

[CA_Punit]

Instead of using +NETWORKDAYS.INTL("5/5/2021","10/5/2021",17)+1)*0.5

Use =SUM(--(WEEKDAY(ROW(INDIRECT(VALUE("05/05/2021")&":"&VALUE("10/05/2021"))),2)=6))*0.5

 

[MyJoy]

Instead of using +NETWORKDAYS.INTL("5/5/2021","10/5/2021",17)+1)*0.5

Use =SUM(--(WEEKDAY(ROW(INDIRECT(VALUE("05/05/2021")&":"&VALUE("10/05/2021"))),2)=6))*0.5

Thanks for the reply but the answer is '0'.

 

[Phuoc]

Try thí:

=NETWORKDAYS.INTL("5/5/2021","10/5/2021",1)+NETWORKDAYS.INTL("5/5/2021","10/5/2021","1111101")*0.5

 

[CA_Punit]

Not Just Press "Enter" after formula..

Press "Ctrl"+"Shift"+"Enter"

 

[MyJoy]

Not Just Press "Enter" after formula..

Press "Ctrl"+"Shift"+"Enter"

May be I did not put it clearly, I need to calculate from 5 May to 10 May total number of working days and Saturday is a half work day Sunday is a off day. Thanks

 

[CA_Punit]

=(NETWORKDAYS.INTL("5/5/2021","10/5/2021",1)+SUM(--(WEEKDAY(ROW(INDIRECT(VALUE("05/05/2021")&":"&VALUE("10/05/2021"))),2)=6))*0.5)

I am getting 4.5 as the solution.

 

[MyJoy]

=(NETWORKDAYS.INTL("5/5/2021","10/5/2021",1)+SUM(--(WEEKDAY(ROW(INDIRECT(VALUE("05/05/2021")&":"&VALUE("10/05/2021"))),2)=6))*0.5)

I am getting 4.5 as

 

[MyJoy]

Hi Everyone,

Can someone help me in this formula answer should be $842.55.

=($D10)/(IF($AB10=$AP$16,(VLOOKUP($N$1:$Y$1,$AN$16:$AR$28,3,0)),IF($AB10=$AQ$16,(VLOOKUP($N$1:$Y$1,$AN$16:$AR$28,4,0)),IF($AB10=$AR$16,(VLOOKUP($N$1:$Y$1,$AN$16:$AR$28,5,0))))))*(NETWORKDAYS.INTL("5/5/2021","16/5/2021",1)+(SUM(--(WEEKDAY(ROW(INDIRECT(VALUE("5/5/2021")&":"&VALUE("16/5/2021"))),2)=6))*0.5)+(SUM($E10:$L10)/(IF($AB10=$AP$16,(VLOOKUP($N$1:$Y$1,$AN$16:$AR$28,3,0)),IF($AB10=$AQ$16,(VLOOKUP($N$1:$Y$1,$AN$16:$AR$28,4,0)),IF($AB10=$AR$16,(VLOOKUP($N$1:$Y$1,$AN$16:$AR$28,5,0))))))*(NETWORKDAYS.INTL("5/5/2021","16/5/2021",1)+(SUM(--(WEEKDAY(ROW(INDIRECT(VALUE("5/5/2021")&":"&VALUE("16/5/2021"))),2)=6))*0.5))))

 

[MyJoy]

Hi Everyone,

Can someone please me in the formula I can't get answer correctly. Thanks.