Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Tool that counts # of business days like Excel function Workdays()

 

Idea:  I need a function that given two dates, will return the number of business days between them. I need to know the # of business days between when a sales order is placed and when it ships to the customer. I'm in the US, so I would want to not count Saturdays, Sundays, and US Holidays, but I can foresee others wanting the option to change to other calendars or ignore holidays.

 

There are a couple of posts on this in the community, but everything I've found so far is too laborious to implement or not robust.

 

4 Comments
Asteroid

Think this would be a great idea. Currently working on a few projects which require this.

Status changed to: Inactive
 

The status of this idea has been changed to 'Inactive'. This status indicates that:

 

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!

Moderator
Moderator
Status changed to: New Idea

This idea is being returned to the New Idea status, as it has reached the required number of likes to be brought to our product teams attention. Please note it may take time for our product team to provide a response. However, we will do our best to insure this idea is updated accordingly.

 

Thank you for posting and contributing to the product idea boards!