Skip to main content

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.

Check the time zone settings for the formula field. You may need to set it to GMT. 


Check the time zone settings for the formula field. You may need to set it to GMT. 


That worked -- thank you dearly, Kuovonne!!


Reply