# IS THIS POSSIBE?

#### vern07

##### New Member

I want column E after row 3 to check if column B=PO, if so look in Column D, if blank return with "no promise date", if a date is entered and the date is within 10 days prior to A2 return with "confirm promise date", if column D is 11 days before A2 or greater then nothing. If blank or Req no action.

#### GraH - Guido

##### Well-Known Member
Try,

=IF (and(B4="PO", D4 >= (\$A\$2-10), D4 <= \$A\$2), "confirm promise date", IF (and(B4="PO", D4=""), "no promise date", "no action"))

PS: please have a read of the forum rules. Sample file and manually entered solution help us help you better, faster and more efficient. + Title? The correct answer is simply "Yes".

#### vern07

##### New Member
Worked like a charm, thank you for the help.

#### vern07

##### New Member
adding another twist, keeping everything you already did. Column E look in column A if not blank and column B is blank return "in process". I'm uploading the file this time

#### Attachments

• 9 KB Views: 2

#### GraH - Guido

##### Well-Known Member
simply add a new IF ( ) before the last false argument.
=IF(AND(B4="PO",D4>=(\$A\$2-10),D4<=\$A\$2),"confirm promise date",IF(AND(B4="PO",D4>\$A\$2),"needs expedited",IF(AND(B4="PO",D4=""),"no promise date",IF(B4="return","in process",""))))

Depending of your version of Excel one could use SWITCH ( ) and avoid the IF-nesting.

For further posts: please make your sample data so that it represents all possible scenarios.

#### Attachments

• 9.4 KB Views: 0