Stop Counting Days

[spr1nger]

I have a hidden column with the =TODAY() function. I am counting days from the time an order was placed to the delivery date. Once the delivery date is entered into a column, I want the column counting the days to stop. What would be the correct formula for that? I'm curing using =IF(C6="","OPEN",N6-C6). C6 is the delivery date & N6 is the hidden today function. The O column is the column showing the number of days.

 

[SanjayGMusafir]

Try this and revert -

=IFS(C6="","Open",C6<>"","Delivered",True,N6-C6)

 

[Joe4]

Do you store Order Date somewhere?
If so, just subtract that from the Delivery Date.

 

[spr1nger]

Try this and revert -

=IFS(C6="","Open",C6<>"","Delivered",True,N6-C6)

That only returns the work "delivered". I want the number of days I just want it to stay the number of days it took to be delivered. Right now, it keeps counting.

 

[Joe4]

If you do not have another field holding the static date (not the TODAY() function, as that is dynamic and not static) that you want to use in the calculation, you will probably need to use VBA code to change the data to a hard-coded date.

 

[SanjayGMusafir]

I want the number of days I just want it to stay the number of days it took to be delivered

In that case you need have an order date in some column and then use following. remember it's generic

=IFS(C6="","Open",C6<>"",C6-OrderDate,True,N6-C6)

 

[spr1nger]

In that case you need have an order date in some column and then use following. remember it's generic

=IFS(C6="","Open",C6<>"",C6-OrderDate,True,N6-C6)

I'm getting #NAME? return

 

[Joe4]

I'm getting #NAME? return

That is because he is just using "OrderDate" as a place-holder for the cell address with Order Date, like I suggested back in my first reply.

I see you don't seem to be addressing any of my comments/posts though. That is fine, if you do not want my help, I will just move along.

 

[spr1nger]

That is because he is just using "OrderDate" as a place-holder for the cell address with Order Date, like I suggested back in my first reply.

I see you don't seem to be addressing any of my comments/posts though. That is fine, if you do not want my help, I will just move along.

Please don't take offense. I'm am at work & I'm getting pulled in different directions. I'm checking this when I can. Plus, I'm not an Excel guru, let alone knowing any VBA codes. I suppose I can replace the today function once it's delivered and that would stop the counting. I was looking formula that would do all of it for me.

 

[Joe4]

Your data description does not make sense to me. The Order Date wouldn't be a changing date, right? It would be the static date that the order was made.
Can you show us an example of exactly what your data looks like, and walk us through an example of when things need to be "frozen"?