Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
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))
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
Thanks! Works great.
How would I alter the expression to count working days for all data and not just '2017'?
How about all the holidays?