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.
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.
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.
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.