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!!!