Finding and Recording Data only on specific Days.

[Guzzlr]

Hello All.
I have a shift, that only works Saturday thru Monday (3 Days)

I have:

Range("T3").Select
ActiveCell.FormulaR1C1 = "3rd Shift Actual Wt."
Range("T4").Select
ActiveCell.Formula = "=IF(AND($B4>=$G$2,$B4<=$H$2),$G4,"""")"
Selection.AutoFill Destination:=Range("T4:T" & Range("A" & Rows.Count).End(xlUp).Row)
Range(Selection, Selection.End(xlDown)).Select

Where G2 and H2 are start and end times of 5:00:00 AM & 4:00:00PM respectively, and on the same day (not crossing midnight into the next day)
Where G4 is data I wish to select

AND

'Add Day of Week
Range("S3").Select
ActiveCell.FormulaR1C1 = "Day of Week"
Range("S4").Select
ActiveCell.Formula = "=IF(A4<>"""",TEXT($A4,""ddd""),"""")"
Selection.AutoFill Destination:=Range("S4:S" & Range("A" & Rows.Count).End(xlUp).Row)
Range(Selection, Selection.End(xlDown)).Select

Where Column A is Date Format of xx/xx/xxxx and column S is the day format of "ddd" from above code.

The problem, is finding the data of column G on the specific days of Saturday, Sunday, and Monday, using the Shift Times in G2 & H2.

Can someone lead me in the right direction please

Thank you

 

[Guzzlr]

I believe I have answered my own question...
I have:

=IF(AND($B4>$G$2,$B4<$H$2)*OR($S4="Sat",$S4="SUN",$S4="Mon"),$G4,"")

This appears to be working

I do have a couple of questions:
1. Why does excel want me to place an "*" before the "OR" statement? Is this acting as a wildcard?
2. Is there a better way of doing this?

Thank you