STOP THE COUNTDOWN WHEN A DATE IS ENTERED

[rsimard9208]

Hi Everyone,
I know the question has been asked and I tried to apply the different formulas that I found on the forums, but can't apply it to my table .

Currently, my column C is counting down from today's date to the date the order was sent.
I would like column C to stop counting down when I enter my termination date in B.

If possible in formula

Otherwise, I am open to try VBA formulas if simpler.
Thanks

 

[mart37]

IF(A3<=$B$3;[your code];"")

 

[Marcílio_Lobão]

rsimard9208, Bonjour.

Utilisez cette formule:

C3 --> =SI(B3=""; AUJOURDHUI()-A3; B3-A3)

Veuillez nous dire si c'est ce que vous vouliez.
J'espère que je t'ai aidé.

 

[Osvaldo Palmeiro]

=IF(B3="",TODAY()-A3,B3-A3)

 

[rsimard9208]

rsimard9208, Bonjour.

Utilisez cette formule:

C3 --> =SI(B3=""; AUJOURDHUI()-A3; B3-A3)

Veuillez nous dire si c'est ce que vous vouliez.
J'espère que je t'ai aidé.

Bonjour,
je vais voir demain si le décompte aura été arrêté !!!
Merci beaucoup

 

[Marcílio_Lobão]

rsimard9208,

You're welcome.

Thanks for the feedback.

We look forward to your final response if it worked as you needed it.

 

[rsimard9208]

rsimard9208,

You're welcome.

Thanks for the feedback.

We look forward to your final response if it worked as you needed it.

Finally it didn't work, my count down stil updating today

 

[Marcílio_Lobão]

rsimard9208, Good morning.

You asked for:

Currently, my column C is counting down from today's date to the date the order was sent.
I would like column C to stop counting down when I enter my termination date in B.

The suggested formula does exactly what you asked for:

While the termination date is not entered the counter is counting how many days it is taking.
As soon as the termination date is entered, the counter ends the count showing how many days have actually been spent for delivery. From that point on, the term is no longer counted.

As this did not solve your doubt, is it that what you want is that nothing appears in the result cell and only when the termination date is inserted does the time calculation appear?

If so, use that formula:

C3 --> =IF(B3=""; ""; B3-A3)

I hope I've helped.