Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-816961%22%20slang%3D%22en-US%22%3EExcel%202013%20-%20if%20date%20is%20found%20between%20date%20range%20return%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-816961%22%20slang%3D%22en-US%22%3EI%20need%20a%20formula%20that%20states%20IF%20B3%20has%20Completed%20AND%20A3%20is%20between%20G2%20and%20H2%20THEN%20return%20what%20is%20in%20C3%20I%20have%20attached%20the%20file%20to%20help%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-816961%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-817040%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202013%20-%20if%20date%20is%20found%20between%20date%20range%20return%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-817040%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396659%22%20target%3D%22_blank%22%3E%40Blackpie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20try%20this...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIF(OR(A3%3D%22%22%2CB3%3D%22%22)%2C%22%22%2CIF(AND(B3%3D%22Completed%22%2CA2%26gt%3B%3D%24G%242%2CA2%26lt%3B%3D%24H%242)%2CC3%2C%22%22))%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Blackpie
Occasional Visitor
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,""))

Related Conversations