Conditioned Date Counter

[newclasshero]

Hello:

Well, I am extremely new here and am a 100% self taught Exceller (if that is a word). I signed on here because I have reached an impasse. A little background may help. I work for a car dealership and my whole job has to do with the vehicles before they get to the dealership. The sooner they get here the better.

Here is what I have got so far:

=IF((TODAY())>AO6,(DATEDIF(AO6,TODAY(),"D")),IF(AW6="Landed",VALUE(DATEDIF(AO6,TODAY(),"D"))," "))

AO6= The day the vehicle went into my system.
AW6 is a validated cell with a couple of choices to reflect the different stages that I have to do before the vehicle gets ot the lot
"Landed" in AW6 is when the vehicle hits the lot.

The problem is I would like the date counter to stop when AO6 says "Landed"

Of course the Today() function in that particular spot returns the number of days from the start till now no matter what AO6 equals.

Any help would be appriciated.

 

[barry houdini]

To do this with a formula I think you'd need to have a cell containing the date when the vehicle "landed". If that cell was AX6 you could use a formula like

=IF(TODAY()>AO6,DATEDIF(AO6,IF(AW6="Landed",AX6,TODAY()),"D"),"")

 

[newclasshero]

Reply

I suppose that I may just be getting a little lazy but I was hoping that as soon as that cell reflected "Landed" that the date that happened would be reflected in the result. The reason for this is because I want to keep track of how many days it is taking for the the vehicles to "land" but when they do, that the result would stay constant but at the same time not having to manually input the date that happened.

 

[newclasshero]

I quess that is also why I tried to use the value function on the today function almost like a Copy + Paste Value manuever. Thank you for the reply still.