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 dateDate WE updatedOver Due?7/19/20217/16/2021 7/19/20217/1/2021 7/19/20217/10/2021 7/19/20217/9/2021 7/19/20217/15/2021 7/19/20217/13/2021 7/19/20217/8/2021 7/19/20217/7/2021 7/19/20217/14/2021 7/19/20217/6/2021 7/19/20217/14/2021 7/19/20217/19/2021 7/19/20217/5/2021 Thank you in advance! Kim

Comparing dates to include only business days

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

Date Time

Accepted answers

AngelosPachis

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

example.yxmd

All comments

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 : )

business days.yxmd

AngelosPachis

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

example.yxmd

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 : )

business days (1).yxmd

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335