If cell contains a date then another cell should turn to sero or blank?

[sissyboot]

Hey all,

New to posting so forgive me if I seem a little green...I am. Here's my issue in a nutshell:

I am trying to track shipping of some items. I have my sheet set up so that it calculates how long we have had an item (so I know when I need to ship it). I need to be able to zero that field out once the item has shipped. So I think I need to be able to create a formula that says if there is a date present in cell O2, then cell E2 should change to either zero or blank. I think I am running into problems because I already have a formula in cell E2 and I can't figure out how to incorporate the two. I have this formula in cell E2:

=IF(A2="","",C2-A2)

I sure hope I am making sense?? I have been staring at this and trying multiple formulas and getting nowhere....any help would sure be appreciated.

Thanks!

[bhenlee]

TRY this:

=IF(OR(a2="",ISNUMBER(o2)),"",C2-A2)

[sissyboot]

That's perfect! You guys are awesome and so quick. I appreciate the help!!

[Aardigspook]

Hi,

A nested IF would also work:

=IF(O2>0,"",IF(A2="","",C2-A2))

Though bhenlee's solution is more elegant

Regards,
Aardigspook

[bhenlee]

You're welcome sissyboot.

Please mark this thread as solve if you're satisfied with the resolution

[Aardigspook]

You're welcome.
And a belated welcome to the forum!