Aug 22 2019 05:16 AM
Aug 22 2019 06:14 AM
@Blackpie
Please try this...
=IF(OR(A3="",B3=""),"",IF(AND(B3="Completed",A2>=$G$2,A2<=$H$2),C3,""))