Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

Calculate Business Days Between Dates

Created on


How do I calculate the number of business days between two dates?


We get this question a lot in Customer Support. It's actually fairly easy to do using a just a few tools.


Assuming your beginning and end date are in two separate fields you can take a look at the sample attached to demonstrate the process.


1) Use the Generate Rows tool to fill in the missing dates

2) Use a Formula tool to create a field with the day of the week for each of the filler dates

3) Use a Filter tool to remove the unwanted days of the week

4) Use the Summarize tool to count the number of days that are left


Note that if you don't already have an unique ID on each record, you'll want to use the Record ID tool to add one to make the summarize process easier.


The sample workflow was built in 10.6, but the same general process can be followed in all versions.


I am having trouble opening up the example file (yxzp) am i missing something ?


Solved my problem now please ignore


Hi Sir,


(DateTimeDiff(["2018-01-10","2018-01-23",'Business Days')) >= 15


How can i code it in alteryx, I am getting confuse,  


Is there a way for this calculation to return a negative number? There are times within my date where the end date is prior to the begin date. It is valid and I need it to return the negative number.