# Conditioned Date Counter

#### newclasshero

##### New Member
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.

### Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
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"),"")

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.

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.

Replies
0
Views
181
Replies
3
Views
1K
Replies
3
Views
417
Replies
1
Views
506
Replies
9
Views
3K

1,203,124
Messages
6,053,645
Members
444,676
Latest member
locapoca

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back