How to exclude the weekend days from network formula?

Question & Answer
,
1

How to exclude the Saturday and Sunday from networkdays formula?

4
41909Ă—820 37 KB

2

Hi @hripraa
maybe you can build a workaround with isWorkDay:

and sum the workdays.

BR

3

Could you pls give me a idea, how to use “isworkday” in my case?

I tried but i don’t know how to use it in my problem.

I need to fined the no. of days b/w create date and resolve date by excluding the weekends

4

netWorkDays should already be giving you the number of working days between 2 dates excluding Sat and Sun.

Can you share an example if this is not the case?

Thanks!

5

@andres007 i just want to write that. :smiley:

grafik

1 Like
6

Kindly refer the below screenshot. where the red highlighted shows wrong count in dashboard. when we use the networkdays formula. only 3 cases not matching may i know the reason?

Capture
Capture1264Ă—698 50.8 KB

7

Can you create a calculated field

netWorkDays(parseDate("01/12/2024","MM/dd/yyyy"),parseDate("01/16/2024","MM/dd/yyyy"))

my outcome is 3

8

Okay i will try this formula