Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music

Alteryx for Excel Users: Find the future date after 'x' working days from [Date]

Alteryx
Alteryx
Created

Finding the future date after 30 from today is easy in Excel.  Use the =TODAY function and add 30.  

 

Date After X Working Days 01.png

 

There's an Alteryx function - DateTimeAdd - that does the same thing:

 

 

2019-04-22_10-17-52.png

 

 

What if we wanted to know the date 30 working/business days from today?  Excel has a function called 'WORKDAY' to do that.

 

Date After X Working Days 03.png

 

And it isn't limited to just today's date.  You can use any date.

 

Date After X Working Days 04.png

 

Finding a future date 'x' working days from today - or any day - in Alteryx is a little trickier.  At least it was.  Attached is an app you can use to pick a date and the number of working days in the future.  

 

2019-04-22_10-18-42.png

 

 

From the snapshot above, you'll see the Calendar macro is used.  There are two versions of this macro.  One where the week begins on Sunday and the other where the week begins on Monday.  In the attached app uses the macro where the week begins Sunday but the macro starting on Monday can easily replace it.  

Attachments