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