Working Days with respect to date compared to yesterday

[Anagha]

Hi,

Could you please help me with a doubt in alteryx?

I have a set of dates which needs to be compared with yesterday's date and find out the number of working days(along with removing Saturdays and Sundays, the public holidays also needs to be removed)between the two dates.

Will the method of finding out the days between the date and yesterday and then filtering out Saturdays and sundays, work? Please find the set of dates and holidays mentioned in the attached file. Kindly help.

Thanks,

Anagha

[fmvizcaino]

Hi @Anagha ,

For this case, I think you can download this macro from the gallery developed by @BenMoss 

https://gallery.alteryx.com/#!app/Working-Day-Time-Difference/5a0ad875f499c708d037257c

If you are not familiar to macros, see the link below from @StephenW  with the instruction in how to install a macro.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Macro-Installation/ta-p/13032

See if that works for you.

Best,

Fernando V.

[afv2688]

Hello @Anagha ,

Hope this helps

Regards

[RolandSchubert · Accepted solution]

Hi @Anagha ,

I used a Generate Rows tool to create a list of days between the "Usable_Day" from your list and yesterday (calculated by a formula). Then I removed all Saturdays and Sundays (idenfitied by a DateTimeFormat function. I used a Join tool to remove the holidays (ony the "not-joined" days remainining) and counted the days.

Hope this is helpful.

Best regards

Roland

[Anagha]

Thank you so much