aryanaveen
Board Regular
- Joined
- Jan 5, 2015
- Messages
- 104
Hi All,
Please help me with the below scenario.
Cell A1 has date, cell B1 has time and Range H1:H8 has list of holiday dates.
Now I need a formula which will check the date, time and holiday list, if Date is a weekday and time is before 06:00:00 PM and the date doesn't fall under holiday list then result should be "received before cutoff" else "received after cutoff.
If date falls under holiday list or Saturday and sunday(weekend) then result should be "received after cutoff".
Please help
<tbody>
</tbody>
Please help me with the below scenario.
Cell A1 has date, cell B1 has time and Range H1:H8 has list of holiday dates.
Now I need a formula which will check the date, time and holiday list, if Date is a weekday and time is before 06:00:00 PM and the date doesn't fall under holiday list then result should be "received before cutoff" else "received after cutoff.
If date falls under holiday list or Saturday and sunday(weekend) then result should be "received after cutoff".
Please help
Date | Time | Cutoff | Holiday list | |||||
01/10/2017 | 12:25:00 PM | 01/11/2017 | ||||||
01/11/2017 | 12:15:00 PM | 01/15/2017 | ||||||
01/12/2017 | 12:55:00 PM | 02/01/2017 | ||||||
01/13/2017 | 12:25:00 PM | 03/15/2017 | ||||||
01/14/2017 | 12:25:00 PM | 04/22/2017 | ||||||
06/30/2017 | ||||||||
12/25/2017 |
<tbody>
</tbody>