Count Business Days

[akuttler]

Hello,

I am trying to create a variable that counts distinct business days in a year.

Count(NetWorkDays('01-01-2017', '12-31-2017', '01-02-2017', '05-29-2017', '07-04-2017', '09-04-2017', '11-23-2017', '12-25-2017' ))

However it gives me "0"

Thanks.

[sunny_talwar · Accepted solution]

Try this

NetWorkDays(MakeDate(2017), MakeDate(2017, 12, 31), MakeDate(2017, 01, 02), MakeDate(2017, 05, 29), MakeDate(2017, 07, 04), MakeDate(2017, 09, 04), MakeDate(2017, 11, 23), MakeDate(2017, 12, 25))

[zebhashmi]

Or change your format maybe like that

NetWorkDays('01/01/2017', '12/31/2017', '01/02/2017','01/02/2017', '05/29/2017', '07/04/2017', '09/04/2017', '11/23/2017', '12/25/2017' )

Regards

[akuttler]

Thanks! Works great.

[akuttler]

How would I alter the expression to count working days for all data and not just '2017'?

[sunny_talwar]

How about all the holidays?