Help

Add 5 Days to a date field while skipping weekends

Topic Labels: Formulas
642 2
cancel
Showing results for 
Search instead for 
Did you mean: 
localemagazine
4 - Data Explorer
4 - Data Explorer

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.

2 Replies 2

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

That worked -- thank you dearly, Kuovonne!!