Calculate between date/time when weekend in between

Question

I have a true false result calculation based on obtaining data between 12pm one day and 12pm the next day.
In cell S2, I have: =TODAY()-1 +12/24
In cell S3, I have: =S2+1 -1/1440

This gives me a true or false in my 'helper' column Q:

=AND(G2>=$S$2,G2<=$S$3)

I extract this data to do other things but I forgot about weekends.

When I look at my data on a Monday afternoon, I get nothing from Friday afternoon (after 12pm) because it is much greater than my calculation.

I tried an IF statement and WEEKDAY equation.

Answer 1

=WORKDAY.INTL(TODAY(),-1)+0.5 and =WORKDAY.INTL(S2,1)+0.5-1/1440 You can even add a list of holidays to skip. – Scott Craner

Answer 2

Would [Column I 👀] ...greater than, less than formula - help?

Note: Column D 👆 ...has a "Zero" (0) for the weekends - but you can adjust the formula to be whatever you want.