Working Days with respect to date compared to yesterday

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

Working Days.xls

Workflow

Help

Accepted answers

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

WorkingDays.yxmd

All comments

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.

Hello @Anagha ,

Hope this helps

Regards

usuable_date_marco.yxzp

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

WorkingDays.yxmd

Thank you so much

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15875

MarqueeCrew 13708

apathetichell 13703