IF statement to "flag" or pull data

[erikw48]

Working in Excel 2013 and I am trying to implement and IF statement that will flag or pull cell data based on the following criteria.

For example:

Book1.xlsx

On the above attached spreadsheet I am trying to populate column E with the Tracking number if the "order scheduled date" was not with 48 hours or 2 days from the "order received date". I am struggling to create the correct formula for this outcome. =IF(B2<(this is the part where I struggle)C2,A2,"").

If anyone has some insight for me on this matter it would be greatly appreciated!

[JohnTopley]

try ....

=IF(DATEDIF(B2,C2,"d")>2,A2,"")

in column E

[sakib]

See attached...

=IF(DATEDIF(B2,C2,"d")>2,A2,"")

Thanks.

[sakib]

Extremely Sorry John Topley as I have not seen your reply before my posting.

I used the same function.....

[erikw48]

Wow! Thank you for the speedy response JohnTopley and sakib! The suggestions worked like a charm!

[azumi]

=if(c2-b2>2,a2,"")

[JohnTopley]

Sakib,
No apology required - we always going get "overlapping" responses.

[sakib]

Thanks JohnTopley...