Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Tricky IF/Then Date based formula needed
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="JMB, post: 3722859"] I noticed a small error. The 5 in {5,6,7} should have been a 0 (not sure how that got there). Also, I notice the 19+Lookup(...) can be made shorter. My revised suggestion would be: =IF(AND(HOUR(A16)>=7,HOUR(A16)<LOOKUP(WEEKDAY(A16,2),{0,6,7},{20,15,16})),"On Time","Closure Time") Sorry about that. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Tricky IF/Then Date based formula needed
Top
