Excel 2013 - if date is found between date range return value

Copper Contributor
I need a formula that states IF B3 has Completed AND A3 is between G2 and H2 THEN return what is in C3 I have attached the file to help
1 Reply

@Blackpie 

 

Please try this...

 

=IF(OR(A3="",B3=""),"",IF(AND(B3="Completed",A2>=$G$2,A2<=$H$2),C3,""))