This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
New Alteryx user here, excited to put the program into use with my team.
I looked through some posts but nothing quite helped with adding a number of business days to a date. Everything I found had how to calculate business days in between, which doesn't help me from what I can tell.
I have a date in a column. I would like a new column to be [date] + 120 business days. What's the best way to go about this?
I would just figure out exactly how many days out 120 weekdays is and add that. 120 weekdays = 24 weeks = 168 days. So just add 168 days. If you wanted to take it up a notch, create a table/excel spreadsheet with company holidays and include a "next business day" column. Join the 2 dates together, anything that comes out of the inner join should then use the "next business date" column.
This is great, thank you. It works well for a table with one record, but doesn't work for tables with multiple records (provides one output date for all records no matter if input dates are different). Any ideas on how to work around that?
Your welcome. If you have questions after you poke around, let me know. I'd recommend looking at the differences between what I originally sent vs the follow up, too. The Multirow Formula Tool is *really* handy a lot of the time.