AnsweredAssumed Answered

Formula to avoid weekend  !!!

Question asked by julianohs on Mar 12, 2015
Latest reply on Mar 12, 2015 by fhunth

Hi Guys !


May anyone help me, please??

 

I´ve been looking for something but not found it yet.

 

I got this formula works =[Due Date]=TODAY()+3... however if the user creates a request at Wed, Thu or Fri ??

 

Imagine today´s Wednesday and the user wants to withdraw a Notebook, so the user must choose on Monday of the next week.

If it is Thursday, the user must choose Tuesday... 
If it is Friday, the user must choose Wednesday...

 

Always add 3 days later but excluding Weekend..

 

Thank you  !
Juliano

Outcomes