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!

1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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
0
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?
0
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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
0
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!
0