Mar 20, 2023 03:00 PM
I am trying to create formulas that skips weekends, showing 5 days after a date field called Sendt (and then two other formula fields for 14 days later and 30 days later)
I tried using the workday function, however it is displaying a Sunday, as you can see in the screen shot below.
I have tried, I kid you not, over 30 different types of formulas and cannot get this to work.
What am I doing wrong and how I can get the formula to spit out the next BUSINESS DAY 5 days after the Sendt date?
For reference 3/27 is a Monday and 4/2 is a Sunday.
Mar 20, 2023 04:26 PM
Check the time zone settings for the formula field. You may need to set it to GMT.
Mar 20, 2023 06:41 PM
That worked -- thank you dearly, Kuovonne!!