Weekday/Weekend Formula

If submitted after 4 pm on Sunday for NEXT Tuesday = "Mail", then this works:

=IF([@[Request Date]]=[@[Submitted Date]],"Local",IF(AND([@[Submitted Time]]>=8/24,[@[Submitted Time]]<16/24,WEEKDAY([@[Submitted Date]],1)<>7),"Mail",IF(OR(AND(WEEKDAY([@[Submitted Date]])>2,WEEKDAY([@[Submitted Date]])<6),AND(WEEKDAY([@[Submitted Date]])=6,[@[Submitted Time]]<8/24)),"Local",IF(([@[Submitted Date]]+MOD(9-WEEKDAY([@[Submitted Date]]),7))<[@[Request Date]],"Mail","Local"))))

If submit date = request date                                              LOCAL
ElseIf submitted on Sunday-Friday after 8am and before 4pm                 MAIL
ElseIf submitted on Friday after 4pm or Saturday, Sunday or Monday...
...AND request date is the following Tuesday or later                      MAIL
Else                                                                       LOCAL

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee