Comparing dates to include only business days

[kas]

Hello,

I am trying to compare dates to determine if a case is  5 business days, or greater, over due. The compare would be between the current date, and an Updated date. The Over due column would be the result - Yes or No.

Sample dates:

Current date	Date WE updated	Over Due?
7/19/2021	7/16/2021
7/19/2021	7/1/2021
7/19/2021	7/10/2021
7/19/2021	7/9/2021
7/19/2021	7/15/2021
7/19/2021	7/13/2021
7/19/2021	7/8/2021
7/19/2021	7/7/2021
7/19/2021	7/14/2021
7/19/2021	7/6/2021
7/19/2021	7/14/2021
7/19/2021	7/19/2021
7/19/2021	7/5/2021

Thank you in advance!

Kim

[atcodedog05]

Hi @kas 

Here is how you can do it. I am taking an assumption that no Date WE updated is older than 30 days.

Workflows:

1. Taking groupby on current date to get a single row of date.

2. Using gen rows generating prev 30 days.

3. Using multi-row formula tool counting only week days.

4. Using find&replace to do vlookup to get business days between values.

5. Using formula tool to check overdue.

Hope this helps : )

[AngelosPachis · Accepted solution]

Hi @kas ,

Here is one way you can do it. For each record you generate all days in between and then keep only business days. Then you can count and assign the Overdue flag

Hope that helps,

Regards,

Angelos

[kas]

@AngelosPachis  This works perfectly...thank you!

[kas]

@atcodedog05 

Thank you for the reply...unfortunately, with your example, the ones with the Updated dates of 7/9 and 7/10 would be over due where your results show as not.

Thanks again,

Kim

[atcodedog05]

Hi @kas 

Thank you for notifiying. Oops the logic was reversed 😅. It was counting non business days instead of business days. I have fixed it.

Workflow:

Hope this helps : )