Date Sequence in Column

[isundari]

Hi. Hello,

I looking to extract employee leave date range, exclude Saturday, Sunday and holiday.

Let's say an employee is taking leave from 8 April 2024 to 16 April 2024.

13 April is Saturday, 14 April is Sunday.

9 - 12 April are holiday.

So the date sequence of his leave are separated into 3 columns, 1st is 8 April 2024, the 2nd column is 15 April 2024, then 16 April 2024.

In ms. excel I can use formula networkday.intl, but in Alteryx, I'm clueless. Really appreciate if anyone can help me with this. Thanks in advance.

[Bren_Spill2 · Accepted solution]

@isundari - see attached. Not sure if this is exactly what you're going for, but this should be a good starting point. One step I didn't include was cleansing your dates which are not in the Alteryx format (YYYY-mm-dd). You can use the Date Time tool or a formula tool for that. Also, check out this link which has everything you need to know about working with dates: DateTime Functions (alteryx.com)

[isundari]

Wowww amazing! 

Thank you so much, @Bren_Spill2 

It works perfectly even in a big data.

 

Thank you and have a good day.

[diegosantos]

Great aproach @Bren_Spill2 You rockt it!