How to calculate Network days?

[Sanjaykumar2109]

Hi connect! 

I am working in payables operation and I'm preparing daily metrics for my work. I don't know how to calculate networking days. I want to know to subtract import date and network days to arrive aging days. Can anyone help me out how to derive this? 

Thanks

[alexnajm]

DateTimeDiff sounds like your best function here, but without knowing your data structure, it’s hard to guess otherwise

[gawa]

@Sanjaykumar2109 If your task is to count week days, you can utilize DateTimeFormat function for filtering out Saturday and Sunday.

DateTimeFormat([Day],"%a")

Here is the snapshot of my approach to do that.(find attached WF for your ready reference)

I guess you want to remove "holidays", too. As the definition of holidays depends on region, basically we need to have pre-defined list of holidays for the regions where you want to do your task. For example, here in Japan, 20th-Mar-2025 is our national holiday but it's not for most of other regions since it's Thursday.

You have to get such a list anyhow to additionally filter out regional holidays. To my knowledge, Alteryx Designer does not have embedded default features to realize it.

[Sanjaykumar2109]

Hello alexnjam! here i want to minsu current date and imported on date but it should also exclude Saturday, Sunday. i need only weekdays to get calculated. 

[Sanjaykumar2109]

Hello Gawa! here i want to minsu current date and imported on date but it should also exclude Saturday, Sunday. i need only weekdays to get calculated. 

[alexnajm]

This can be added to any workflow to calculate the remaining das in the current month. you can Append this into your real workflow and use Formulas from there