Previous Topic Next Topic

IF function with Date addition

Solved/Closed
garycrant Posts 3 Registration date Sunday 21 September 2014 Status Member Last seen 25 September 2014 - 21 Sep 2014 à 22:39
garycrant Posts 3 Registration date Sunday 21 September 2014 Status Member Last seen 25 September 2014 - 25 Sep 2014 à 18:41
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

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
23 Sep 2014 à 11:06
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 21 September 2014 Status Member Last seen 25 September 2014
23 Sep 2014 à 16:44
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
25 Sep 2014 à 10:51
Hi Garycrant,

Not at all.

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

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

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

Similar discussions

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

3 responses
How to disable Fn keys
HENRY -
ZiaRahman -

30 responses
fn key + space bar?
Zideh -
ellabella -

14 responses