Previous Topic Next Topic

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

Answer 1 / 1
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
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 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
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

Similar discussions

If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response
"Sorry, this feature isn't available ... " how to fix this?
Anonymous User -
heclam -

3 responses
We'll take a look at the documents you submitted and get back
zaghlul -
rashidayoob161 -

8 responses
How to disable Fn keys
HENRY -
ZiaRahman -

30 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses