Skip to main content

Add 5 Days to a date field while skipping weekends

  • March 20, 2023
  • 2 replies
  • 42 views

Forum|alt.badge.img+1

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

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • March 20, 2023

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


Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • March 21, 2023

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


That worked -- thank you dearly, Kuovonne!!