I got some great help yesterday.
I have one more condition I would like to add onto a formula.
Here is the formula that was given to me =IF(OR(A1="",A2=""),"",A2-A1)
Here what I need information on now with.
OK cell A1 will hold a date that material came in.
Then cell A2 will hold today=() or now=() for todays date.
Cell A3 will be the date that holds the time that has passed.
What I need now is for cell A4 to hold a date. This will be the date that something ships out. What I need it to do is stop the counting in cell A3. I do not need for cells A1 and A3 to depend on this, just cell A3.
If need be you can email me at [email protected]