I have a spreadsheet with a start date/time and End Date/Time in two columns. I need to figure out if at any point these dates include a business day (Not weekends) between 8:00am and 8:00pm. I don't care about Holidays at the moment.
I built an IF statement that works when either of the two dates/times occur during a weekday between 8-8. The problem is when the two dates span multiple days and neither date/time falls between 8-8 on a weekday.
I started trying to build a nested IF to handle certain conditions but having something start on Friday after 8:00pm is stumping me.
I looked into Networkdays() function but our systems are locked down at work and I can't install any add-ons.
Surely there must be a way to make this work.
Thanks in advance for any input.