How to use Network day formula in altreyx

[MaheshR]

Dear All,

Good day,

I want to use the network days formula to be used in altrexy. For your reference, I have attached my spreadsheet results.

Formula used as = Networkday(imported on - today)-1

Need your support.

Document Id     Imported On Today         Ageing     Slab

24715837	06-11-20	08-11-20	0	0-1 Day
24715838	06-11-20	08-11-20	0	0-1 Day
24703971	05-11-20	08-11-20	1	0-1 Day
24703972	05-11-20	08-11-20	1	0-1 Day
24703991	05-11-20	08-11-20	1	0-1 Day
24690849	04-11-20	08-11-20	2	2 Day
24697309	04-11-20	08-11-20	2	2 Day
24697319	04-11-20	08-11-20	2	2 Day
24690091	03-11-20	08-11-20	3	3-5 Days
24690092	03-11-20	08-11-20	3	3-5 Days
24690219	03-11-20	08-11-20	3	3-5 Days
24690220	03-11-20	08-11-20	3	3-5 Days
24690221	03-11-20	08-11-20	3	3-5 Days
24690222	03-11-20	08-11-20	3	3-5 Days
24697310	01-11-20	08-11-20	4	3-5 Days

[messi007]

Dear @MaheshR,

There's actually a macro that was built to do this on the gallery: https://gallery.alteryx.com/#!app/Count-Weekdays/5862c055a18e9e0ff8d854cd.

 It also gives you the option to excluded some days like holidays.

Hope that helps 🙂

Regards,

[Qiu]

@MaheshR 

Macro from @messi007 is a good one. I give it a try and hope it helps.

[MaheshR]

@tqu 

I am unable to download the file.  Can you please check and re-send it?

Regards,

Mahesh

[Qiu]

@MaheshR 
I unzip the package here. Hope it works for you.