Try this in G2
=IF(AND(WEEKDAY($D2,2)<6,MOD($D2,1)<TIMEVALUE("22:00:00"),$E2-$D2<=TIMEVALUE("2:00:00")),"Yes","No")
Try this in G2
=IF(AND(WEEKDAY($D2,2)<6,MOD($D2,1)<TIMEVALUE("22:00:00"),$E2-$D2<=TIMEVALUE("2:00:00")),"Yes","No")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks