Net Workdays

Kinetic_analytics

Hello Alteryx:

How can I convert this excel formula into Alteryx?

=NETWORKDAYS(A2, TODAY())

Appreciate your help.

Thanks

Networkdays.xlsx

Workflow

Date Time

Accepted answers

Mchappell67

Hi -

I came up with a single-tool solution:

The Formula tool calculates a few, relatively simple numbers, and determines the number of work days. I've run a few test cases, and they all tie to the Excel function. Dataset and workflow attached.

Mark

Networkdays.xlsx

networkdays.yxmd

All comments

Maskell_Rascal

Hi @Kinetic_analytics

There is no specific formula to recreate this function in Alteryx, but we can recreate the output with a couple tools.

I'm using a Generate Rows tool to create all dates between the input date and today's date, then identifying the day of the week for each date, filtering out the weekends, and finally using a Summarize tool to count the days.

In the example I provided, I've included a Join tool just to validate that the output matches your desired output.

Let me know if this works for you.

Cheers!

Phil

Calculate Net Workdays.yxmd

Mchappell67

Hi -

I came up with a single-tool solution:

The Formula tool calculates a few, relatively simple numbers, and determines the number of work days. I've run a few test cases, and they all tie to the Excel function. Dataset and workflow attached.