Guest User

Untitled

a guest
Nov 17th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. =WEEKDAY(Start,2)<6
  2. =WEEKDAY(Request,2)<6
  3. =(Request-Start)>2
  4. =NOT(AND(WEEKDAY(Start,2)>2,(Request-Start)<5))
  5.  
  6. =AND( WEEKDAY(Start,2)<6,
  7. WEEKDAY(Request,2)<6,
  8. (Request-Start)>2,
  9. NOT(AND(WEEKDAY(Start,2)>2,(Request-Start)<5))
  10. )
  11.  
  12. =AND( WEEKDAY(Today(),2)<6,
  13. WEEKDAY(Request,2)<6,
  14. (Request-Today())>2,
  15. NOT(AND(WEEKDAY(Today(),2)>2,(Request-Today())<5))
  16. )
Add Comment
Please, Sign In to add comment