AnsweredAssumed Answered

A date field to should let user to choose only business days on the form

Question asked by ramsam on Dec 28, 2017
Latest reply on Jan 5, 2018 by ramsam

Hi Team,

I have a requirement and I need help in building a formula.

I have a field called Preferred Dead line ( date field) , where user cannot  enter a date below 5 days from today( the day whenever the user submitted the form).

I have created the rule ( using Datediffdays function)  and it is working fine, the problem is it should not include weekends 

For example if user enter the request on Thursday the calculation for the 5 days will be Thursday, Friday, Monday, Tuesday, Wednesday. So the user should not enter any of those days before / on Wednesday.


I hope I explained it clearly.


Any help much appreciated!


Thanks in Advance!!!