No. of Business Days

[JagannathaBD]

Hi Team,

Is there any possible to correct the attached macro file;

* Insert new column "Age" and "Age" Column output should be Number of Business Days Calculation based on Start Date and End Date minus Holiday and Saturday and Sunday.

Please let me know if required addition info in this macro. 

Thank you,

Regards,

Jagannatha BD

[KaneG]

Hi,

There are lots of examples of BusinessDays calcs around. You should be able to get an idea of how to perform this from one of the below samples:

• https://gallery.alteryx.com/#!app/Count-Weekdays/5862c055a18e9e0ff8d854cd
• https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Business-Day-formula/td-p/48451