business days

[ntudev]

I need a formula that will give me 5 business days prior to today. Any ideas? So if today is Monday June 20th, i would like a new column that just says June 13th.

[Luke_C]

Hi @ntudev 

Here's one way: Create a record for the prior week from each date, filter out weekends, and take the earliest remaining date.

This is a very common ask, so definitely search around the community for more approaches and ways to add handling for holidays, etc.

[HomesickSurfer]

Hi @ntudev 

You may benefit from calculating each of the past 5 business days and excluding observed holiday dates...filter to x- date you desire.

Hope you like it.  Workflow attached.

[christine_assaad]

Hi @ntudev 

I used a formula tool to get what you are looking for. I love Generate row tool used by @Luke_C  and love the forward thinking of @HomesickSurfer . You have all options.