Calculate 30 Business Day Excluding Weeknds

(0) Share

Report

Posted on by mssa12345

111

Hello All-

I have a flow where I need to find 30 business day prior to utcNOw() excluding weekends. So if today is 11-03-2023 find a date 30 days prior to 11-03-2023 excluding weekends.

Can you please guide me on how would I go about achieving this ?

Thank you very much in advance.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

You will need to specify where you are, what counts as weekend where you are (there's a sizable portion of the world where the weekend is not sat/sun), and you will also want to include/exclude holidays from your calculation.

Ideally you have a calendar table that has these details already prefilled.

Or you could just subtract 42 from utcnow and be done with it.

Was this reply helpful? Yes No
mssa12345 111 on at

Like (0)

Report

@lbendlin thanks for the response, I am based off of USA so what I was looking to do is if user select todays date calculate 30 business day prior to today. I just don't want to count weekends ( Saturday and Sunday), holidays are fine.
Thank you.

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (1)

Report

Did you consider the suggestion to subtract 42?

Was this reply helpful? Yes No
mssa12345 111 on at

Like (0)

Report

@lbendlin I will try that so does that mean if we subtract 14 for 10 business days, subtract 28 for 20 business days, and 42 for 30 business days ? Will this output the valid dates ?
Thank you.

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

for two weekend days per week and not considering holidays, yes.

Was this reply helpful? Yes No