IF function with Date addition

Solved/Closed
garycrant Posts 3 Registration date Sunday September 21, 2014 Status Member Last seen September 25, 2014 - Sep 21, 2014 at 10:39 PM
garycrant Posts 3 Registration date Sunday September 21, 2014 Status Member Last seen September 25, 2014 - Sep 25, 2014 at 06:41 PM
Hello,



I'm having trouble finding an answer as to how I can add 5 more days in my condition.

I have 4 columns:
one for an Order date (A2), a second for the Estimated arrival date (B2), a third for the actual Date of the arrival (C2) and a fourth for the Status of the order (Received, Pending or Late).

Basically, if the actual Date of arrival has 5 or more days+ than the Estimated date, I want the status to say Late. I tried =IF C2>B2+2 in the Logical test section, and I guess that's not how you're supposed to do it.

Can anybody help me on this?

Thank you in advanced!
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Sep 23, 2014 at 11:06 AM
Hi Garycrant,

Not sure where you get the 2 in your formula attempt, but try this:
=IF(C2-B2>4,"Late","Not Late")

Best regards,
Trowa
garycrant Posts 3 Registration date Sunday September 21, 2014 Status Member Last seen September 25, 2014
Sep 23, 2014 at 04:44 PM
Hello TrowaD,

Thank you for your response.

I meant +4, sorry, guess I spent so much time looking at numbres it was hard to see straight.

I entered the formula you suggested, and it works!

I have another question along with my initial one: if the Date of arrival (C2) cell is empty, I would like it to have 'Pending' appear.Would that be too many formulas in one function?
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Sep 25, 2014 at 10:51 AM
Hi Garycrant,

Not at all.

=IF(C2="","Pending",IF(C2-B2>4,"Late","Not Late"))

Best regards,
Trowa
garycrant Posts 3 Registration date Sunday September 21, 2014 Status Member Last seen September 25, 2014
Sep 25, 2014 at 06:41 PM
This did exactly what I wanted it to do.

Thank you again Trowa, you've been a great help!